DBA Data[Home] [Help]

APPS.CSI_INV_TXNSTUB_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 73: (SELECT order_number FROM oe_order_headers_all WHERE header_id IN

69: FROM csi_transactions
70: WHERE source_line_ref_id = pc_transaction_id
71: AND transaction_type_id in (51,54,401)
72: AND source_header_ref IN
73: (SELECT order_number FROM oe_order_headers_all WHERE header_id IN
74: (SELECT header_id FROM oe_order_lines_all WHERE line_id = pc_transaction_id));
75:
76: r_csi_soful_exist_txns c_csi_soful_exist_txns%rowtype;
77: