Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, November 23, 2011

PO_REQ_DISTRIBUTIONS_ALL

Purchasing
Table Or View: Table

Important columns: 
DISTRIBUTION_ID : Requisition distribution unique identifier
LAST_UPDATE_DATE : Standard Who column
LAST_UPDATED_BY : Standard Who column
REQUISITION_LINE_ID : Requisition line unique identifier
SET_OF_BOOKS_ID : Set of Books unique identifier
CODE_COMBINATION_ID : Unique identifier for the General Ledger charge account
DISTRIBUTION_NUM : Distribution number
ALLOCATION_TYPE : Method of allocation across distributions. Can be PERCENT

Description: 
PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. You need one row for each requisition distribution you create. Each row includes the Accounting Flexfield ID and requisition line quantity.
 
PO_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect