๐Ÿ”น Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. ๐Ÿ“Œ Telegram Group : https://t.me/OracleApps88

๐Ÿ’ก Facing issues copying code/scripts or viewing posts? We're here to help!
๐Ÿ“ฌ Contact on Telegram : https://t.me/apps88
๐Ÿ“ฑ Telegram/WhatsApp: +91 905 957 4321
๐Ÿ“ง Email Support: OracleApp88@Yahoo.com

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