DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on OE_ORDER_HEADERS_ALL

Line 1147: , oe_order_headers_all oeh

1143: , To_number(NULL)
1144: , To_char(NULL)
1145: , To_char(NULL)
1146: FROM oe_order_lines_all oel
1147: , oe_order_headers_all oeh
1148: --, wf_item_activity_statuses wf
1149: --, wf_process_activities wpa
1150: WHERE oel.header_id = oeh.header_id
1151: AND oel.header_id = v_oe_order_header_id

Line 1190: , oe_order_headers_all oeh

1186: ,v_task_id NUMBER)
1187: IS
1188: SELECT COUNT(*)
1189: FROM oe_order_lines_all oel
1190: , oe_order_headers_all oeh
1191: --, wf_item_activity_statuses wf
1192: --, wf_process_activities wpa
1193: WHERE oel.header_id = oeh.header_id
1194: AND oel.header_id = v_oe_order_header_id