purchasing(po) module important tables

--PURCHASING MODULE IMPORTANT TABLES--------

--REQUISITIONS

Select * from PO_REQUISITION_HEADERS_ALL

Select * from PO_REQUISITION_LINES_ALL

Select * from PO_REQ_DISTRIBUTIONS_ALL

--RFQ

Select * from PO_HEADERS_ALL--(TYPE_LOOKUP_CODE='RFQ')

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

--QUATATIONS

Select * from PO_HEADERS_ALL----(TYPE_LOOKUP_CODE='RQUATAION)

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

--PO AGREEMENTS

--1)STANDARD

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

--2)PLANNED

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL--(PO_RELEASE_ID IS NULL)

--3)BLANKAT

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

--4)CONTRACT

Select * from PO_HEADERS_ALL

--PORELEASES

--1)PLANNED

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL--(PO_RELEASE_ID IS NOT NULL)

--2)BLANKAT

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

--3)CONTRACT

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL--(CONTRACT_ID IS NOT NULL)

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

Select * from PO_HEADERS_ALL

--RECIEPT

Select * from RCV_SHIPMENT_HEADERS

Select * from RCV_SHIPMENT_LINES

Select * from RCV_TRANSACTIONS

--EMPLOYEE

Select * from PER_ALL_PEOPLE_F

--JOB

Select * from PER_JOBS

--POSITION

Select * from PER_ALL_POSITIONS

--EMPLOYEE'S JOB AND POSITION

Select * from PER_ALL_ASSIGNMENTS_F

--APPROVAL GROUPS

Select * from PO_CONTROL_GROUPS_ALL

Select * from PO_CONTROL_RULES

--APPROVAL MANAGER

Select * from PO_POSITION_CONTROLS_ALL

--POSITION HIERARCHY

Select * from PER_POSITION_STRUCTURES

Select * from PER_POS_STRUCTURE_ELEMENTS

--PO TYPES

Select * from PO_DOCUMENT_TYPES

Select * from PO_VENDORS --(AP_SUPPLIERS IN R12)

Select * from PO_VENDOR_SITES_ALL --(AP_SUPPLIER_SITES_ALL IN R12)

Select * from PO_VENDOR_CONTACTS --(AP_SUPPLIER_CONTACTS) IN R12

--SHIP TO,BILL TO

Select * from HR_LOCATIONS

--PO LINE TYPES

Select * from PO_LINE_TYPES_TL

--AGENTS

Select * from PO_AGENTS_V

--UOM

Select * from MTL_UNITS_OF_MEASURE_TL

Select * from GL_CODE_COMBINATIONS