Now you can Subscribe using RSS

Submit your Email

Monday, 12 August 2013

P2P Table Descriptions

KULDEEP CHAUHAN





P2P Tables With Details


1.PO_REQUISITION_HEADERS_ALL

2.PO_REQUISITION_LINES_ALL
When you raise the Requisition these tables effected 

3.PO_REQUISITION_HEADER_ID is the join between the tables



4.PO_REQ_DISTRIBUTIONS_ALL
It distribute the Requisition Account information.



5.PO_HEADERS_ALL  (PO_HEADER_ID)



6.PO_LINES_ALL
When PO Created PO stores in tables(PO_HEADER_ID) is the join for tables



7.PO_DISTRIBUTIONS_ALL
It will distribute the PO# Account information



8.PO_ACTION_HISTORY
Here you can get Approvals notification Status



9.PO_VENDORS  (VENDOR_ID)



10.PO_VENDOR_SITES_ALL  (VENDOR_SITE_ID)



11.PO_VENDOR_CONTACTS  (VENDOR_CONTACT_ID)
Contacts Vendor ,Vendor site and contact information Vendor_id,Vendor_contact_id, (VENDOR_SITE_ID)


12. RCV_SHIPMENT_HEADERS   (SHIPMENT_HEADER_ID)
Common information about the source of your receipts or expected receipts


13. RCV_SHIPMENT_LINES
When you issue the receipt The recipient number , Shipment location stores in the table.


14. RCV_TRANSACTIONS  (TRANSACTION_ID)


15. MTL_MATERIAL_TRANSACTIONS  (TRANSACTION_ID)
Stores material transaction information (Transaction_id)



16.PO_RELEASES_ALL
To see the which purchase order is released.



17.PO_AGENTS
Contains information about buyers and purchasing managers.



18.PO_NOTIFICATION_CONTROLS
Contains information about the notification control rules for blanket, planned, and contract purchase orders.



19.PO_APPROVAL_LIST_HEADERS
List of approves for the purchasing document used for requisition approvals only



20.PO_APPROVAL_LIST_LINES
Approval list lines for the requisition approval list.



21.PO_POSITION_CONTROLS_ALL
Assignment of control groups to jobs and/or positions


22.PO_DOCUMENT_TYPES_ALL_B

Default, control, and option information you provide to customize



23.PO_CONTROL_GROUPS_ALL

Control groups you use in your business



24.PO_RFQ_VENDORS

Information about the set of suppliers assigned to a request for quotation (RFQ)



25.PO_VENDOR_LIST_HEADERS  (VENDOR_LIST_HEADER_ID)

Stores information about supplier quotation lists you create.



26.FINANCIALS_SYSTEM_PARAMS_ALL

This Tables stores common and default information between AP and PO.


KULDEEP CHAUHAN / Author & Editor

"A Guide for Oracle E-business Suit" . For any Query and help Please drop your mail on - Oracleappsguide.com@gmail.com . Thanks a lot for your visit on OracleAppsGuide.com .Please Subscribe and Comment our website feed and Youtube channel.

0 comments:

Post a comment

OracleAppsGuide.com © Coprights 2016,