DBA Data[Home] [Help]

APPS.OE_XML_PROCESS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 577: from oe_order_lines_all

573: End If;
574:
575: select ordered_quantity
576: into x_ordered_quantity
577: from oe_order_lines_all
578: where orig_sys_document_ref = p_orig_sys_document_ref
579: and orig_sys_line_ref = p_orig_sys_line_ref
580: and orig_sys_shipment_ref = p_orig_sys_shipment_ref
581: and order_source_id = p_order_source_id

Line 633: from oe_order_lines_all

629:
630:
631: select order_quantity_uom
632: into x_ordered_quantity_uom
633: from oe_order_lines_all
634: where orig_sys_document_ref = p_orig_sys_document_ref
635: and orig_sys_line_ref = p_orig_sys_line_ref
636: and orig_sys_shipment_ref = p_orig_sys_shipment_ref
637: and order_source_id = p_order_source_id

Line 812: From oe_order_lines_all

808:
809: Begin
810: Select orig_sys_document_ref
811: Into l_dummy
812: From oe_order_lines_all
813: Where orig_sys_document_ref = p_orig_sys_document_ref
814: And orig_sys_line_ref = p_orig_sys_line_ref
815: And orig_sys_shipment_ref = p_orig_sys_shipment_ref
816: And order_source_id = p_order_source_id