DBA Data[Home] [Help]

APPS.QP_CROSS_ORDER_VOLUME_LOAD dependencies on OE_ORDER_LINES_ALL

Line 431: oe_order_lines_all lines,

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
435: AND lines.org_id = hou.organization_id

Line 512: oe_order_lines_all lines

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'
516: AND lines.sold_to_org_id is not null

Line 659: oe_order_lines_all lines,

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
663: AND lines.org_id = hou.organization_id

Line 723: oe_order_lines_all lines

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
727: AND lines.booked_flag = 'Y'