FND Design Data [Home] [Help]

Table: AHL_OSP_ORDERS_B

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores the osp order header information.
Implementation/DBA Data: TableAHL.AHL_OSP_ORDERS_B
Primary Key: AHLOSP_ORDERS_B_PK
  1. ColumnOSP_ORDER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_OSP_ORDERS_B FK Joins to TablePO_VENDORS AHL_OSP_ORDERS_B.VENDOR_ID
AHL_OSP_ORDERS_B FK Joins to TableHZ_PARTIES AHL_OSP_ORDERS_B.CUSTOMER_ID
AHL_OSP_ORDERS_B FK Joins to TablePO_HEADERS_ALL AHL_OSP_ORDERS_B.PO_HEADER_ID
AHL_OSP_ORDERS_B FK Joins to TableOE_ORDER_HEADERS_ALL AHL_OSP_ORDERS_B.OE_HEADER_ID
AHL_OSP_ORDERS_B FK Joins to TableOKC_K_HEADERS_B AHL_OSP_ORDERS_B.CONTRACT_ID
AHL_OSP_ORDERS_B FK Joins to TablePO_AGENTS AHL_OSP_ORDERS_B.PO_AGENT_ID
AHL_OSP_ORDERS_B FK Joins to TablePO_REQUISITION_HEADERS_ALL AHL_OSP_ORDERS_B.PO_REQ_HEADER_ID
TableAHL_OSP_ORDERS_TL FK Joins to AHL_OSP_ORDERS_B AHL_OSP_ORDERS_TL.OSP_ORDER_ID
TableAHL_OSP_ORDER_LINES FK Joins to AHL_OSP_ORDERS_B AHL_OSP_ORDER_LINES.OSP_ORDER_ID