eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PO_REQUISITION_LINES_ALL

Product:	PO - Purchasing
Description:	Requisition lines
Implementation/DBA Data:	PO.PO_REQUISITION_LINES_ALL

Primary Key: PO_REQUISITION_LINES_PK

REQUISITION_LINE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_REQUISITION_LINES_ALL	PO_REQUISITION_HEADERS_ALL	PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID
PO_REQUISITION_LINES_ALL	PO_LINE_TYPES_B	PO_REQUISITION_LINES_ALL.LINE_TYPE_ID
PO_REQUISITION_LINES_ALL	MTL_CATEGORIES_B	PO_REQUISITION_LINES_ALL.CATEGORY_ID
PO_REQUISITION_LINES_ALL	PO_AGENTS	PO_REQUISITION_LINES_ALL.SUGGESTED_BUYER_ID
PO_REQUISITION_LINES_ALL	PO_LINE_LOCATIONS_ALL	PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID
PO_REQUISITION_LINES_ALL	FND_CURRENCIES	PO_REQUISITION_LINES_ALL.CURRENCY_CODE
PO_REQUISITION_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PO_REQUISITION_LINES_ALL.RATE_TYPE
PO_REQUISITION_LINES_ALL	PO_UN_NUMBERS_B	PO_REQUISITION_LINES_ALL.UN_NUMBER_ID
PO_REQUISITION_LINES_ALL	PO_HAZARD_CLASSES_B	PO_REQUISITION_LINES_ALL.HAZARD_CLASS_ID
PO_REQUISITION_LINES_ALL	PO_REQUISITION_LINES_ALL	PO_REQUISITION_LINES_ALL.PARENT_REQ_LINE_ID
PO_REQUISITION_LINES_ALL	WIP_ENTITIES	PO_REQUISITION_LINES_ALL.WIP_ENTITY_ID
PO_REQUISITION_LINES_ALL	WIP_LINES	PO_REQUISITION_LINES_ALL.WIP_LINE_ID
PO_REQUISITION_LINES_ALL	WIP_REPETITIVE_SCHEDULES	PO_REQUISITION_LINES_ALL.WIP_REPETITIVE_SCHEDULE_ID
PO_REQUISITION_LINES_ALL	BOM_RESOURCES	PO_REQUISITION_LINES_ALL.BOM_RESOURCE_ID
PO_REQUISITION_LINES_ALL	AP_TAX_CODES_ALL	PO_REQUISITION_LINES_ALL.TAX_CODE_ID
PO_REQUISITION_LINES_ALL	PO_HEADERS_ALL	PO_REQUISITION_LINES_ALL.BLANKET_PO_HEADER_ID
PO_REQUISITION_LINES_ALL	PO_VENDORS	PO_REQUISITION_LINES_ALL.VENDOR_ID
PO_REQUISITION_LINES_ALL	PO_VENDOR_SITES_ALL	PO_REQUISITION_LINES_ALL.VENDOR_SITE_ID
PO_REQUISITION_LINES_ALL	PO_VENDOR_CONTACTS	PO_REQUISITION_LINES_ALL.VENDOR_CONTACT_ID
JAI_PO_REQ_LINES	PO_REQUISITION_LINES_ALL	JAI_PO_REQ_LINES.REQUISITION_LINE_ID
JAI_PO_REQ_LINE_TAXES	PO_REQUISITION_LINES_ALL	JAI_PO_REQ_LINE_TAXES.REQUISITION_LINE_ID
MTL_KANBAN_CARD_ACTIVITY	PO_REQUISITION_LINES_ALL	MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID
MTL_SUPPLY	PO_REQUISITION_LINES_ALL	MTL_SUPPLY.REQ_LINE_ID
OE_DROP_SHIP_SOURCES	PO_REQUISITION_LINES_ALL	OE_DROP_SHIP_SOURCES.REQUISITION_LINE_ID
PON_AWARD_ALLOCATIONS	PO_REQUISITION_LINES_ALL	PON_AWARD_ALLOCATIONS.ORIG_REQ_LINE_ID
PON_AWARD_ALLOCATIONS	PO_REQUISITION_LINES_ALL	PON_AWARD_ALLOCATIONS.SPLIT_REQ_LINE_ID
PON_BACKING_REQUISITIONS	PO_REQUISITION_LINES_ALL	PON_BACKING_REQUISITIONS.REQUISITION_LINE_ID
PO_REQUISITIONS_INTERFACE_ALL	PO_REQUISITION_LINES_ALL	PO_REQUISITIONS_INTERFACE_ALL.REQUISITION_LINE_ID
PO_REQUISITION_LINES_ALL	PO_REQUISITION_LINES_ALL	PO_REQUISITION_LINES_ALL.PARENT_REQ_LINE_ID
PO_REQ_DISTRIBUTIONS_ALL	PO_REQUISITION_LINES_ALL	PO_REQ_DISTRIBUTIONS_ALL.REQUISITION_LINE_ID
RCV_SHIPMENT_LINES	PO_REQUISITION_LINES_ALL	RCV_SHIPMENT_LINES.REQUISITION_LINE_ID
RCV_SUPPLY	PO_REQUISITION_LINES_ALL	RCV_SUPPLY.REQ_LINE_ID
RCV_TRANSACTIONS	PO_REQUISITION_LINES_ALL	RCV_TRANSACTIONS.REQUISITION_LINE_ID
RCV_TRANSACTIONS_INTERFACE	PO_REQUISITION_LINES_ALL	RCV_TRANSACTIONS_INTERFACE.REQUISITION_LINE_ID
SO_DROP_SHIP_SOURCES	PO_REQUISITION_LINES_ALL	SO_DROP_SHIP_SOURCES.REQUISITION_LINE_ID