APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on OE_ORDER_HEADERS_ALL

Line 430: FROM oe_order_headers_all hdrs,

426: P_program_appl_id,
427: P_conc_program_id,
428: sysdate,
429: p_request_id
430: FROM oe_order_headers_all hdrs,
431: oe_order_lines_all lines,
432: hr_operating_units hou,
433: gl_sets_of_books gsob
434: WHERE hdrs.header_id = lines.header_id

Line 511: FROM oe_order_headers_all hdrs,

507: P_program_appl_id,
508: P_conc_program_id,
509: sysdate,
510: p_request_id
511: FROM oe_order_headers_all hdrs,
512: oe_order_lines_all lines
513: WHERE hdrs.header_id = lines.header_id
514: AND lines.inventory_item_id = i.c_inventory_item_id
515: AND lines.line_category_code <> 'RETURN'

Line 658: FROM oe_order_headers_all hdrs,

654: P_program_appl_id,
655: P_conc_program_id,
656: sysdate,
657: P_request_id
658: FROM oe_order_headers_all hdrs,
659: oe_order_lines_all lines,
660: hr_operating_units hou,
661: gl_sets_of_books gsob
662: WHERE hdrs.header_id = lines.header_id

Line 722: FROM oe_order_headers_all hdrs,

718: P_program_appl_id,
719: P_conc_program_id,
720: sysdate,
721: P_request_id
722: FROM oe_order_headers_all hdrs,
723: oe_order_lines_all lines
724: WHERE hdrs.header_id = lines.header_id
725: AND lines.line_category_code <> 'RETURN'
726: AND lines.sold_to_org_id is not null