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

AP_HOLDS_ALL

Important columns: 
  1. INVOICE_ID : Invoice identifier
  2. LINE_LOCATION_ID :  Purchase order line location identifier
  3. HOLD_LOOKUP_CODE : Name of hold code
  4. HELD_BY : User that placed hold on invoice
  5. HOLD_DATE : Date user placed hold on invoice
  6. HOLD_REASON : Reason for hold being placed on invoice
  7. RELEASE_LOOKUP_CODE : Name of release code
  8. RELEASE_REASON : Reason for release being placed on invoice
  9. LINE_NUMBER : Invoice line number of the applied hold
  10. HOLD_ID : Hold identifier
    WF_STATUS :  Holds resolution workflow status

Description: 
AP_HOLDS_ALL contains information about holds that you or your Oracle Payables application place on an invoice. For non-matching holds, there is one row for each hold placed on an invoice. For matching holds, there is one row for each hold placed on an invoice-shipment match. An invoice may have one or more corresponding rows in this table. Your Oracle Payables application does not pay invoices that have one or more unreleased holds recorded in this table.
This table holds information referenced by the Invoice Holds window.
In the strictest sense, AP_HOLDS_ALL has no primary key. It is possible for your Oracle Payables application to place a certain type of hold on an invoice, then release it, then place another hold of the same type (if data changes before each submission of Payables Invoice Validation), which would result in a duplicate primary key. But for practical purposes, the primary key is a concatenation of INVOICE_ID, LINE_LOCATION_ID, and HOLD_LOOKUP_CODE.

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