APPS.OKC_XPRT_QUOTE_INT_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 707: Aso_Quote_Lines_all lines

703: items.concatenated_segments
704: BULK COLLECT INTO x_line_var_value_tbl.item
705: FROM
706: Mtl_System_Items_vl items,
707: Aso_Quote_Lines_all lines
708: WHERE
709: lines.inventory_item_id = items.INVENTORY_ITEM_ID
710: AND lines.organization_id = items.organization_id
711: AND lines.LINE_CATEGORY_CODE = 'ORDER'

Line 724: Aso_Quote_Lines_all lines,

720: cats.category_concat_segs
721: BULK COLLECT INTO x_line_var_value_tbl.category
722: FROM
723: Mtl_Item_Categories mic,
724: Aso_Quote_Lines_all lines,
725: Mtl_Categories_V cats
726: WHERE
727: lines.inventory_item_id = mic.INVENTORY_ITEM_ID
728: AND mic.category_id = cats.category_id

Line 842: aso_quote_lines_all quote

838: quote.org_id
839: FROM
840: aso_payments payments,
841: aso_shipments shipments,
842: aso_quote_lines_all quote
843: WHERE
844: quote.quote_line_id = payments.quote_line_id(+)
845: AND quote.quote_line_id = shipments.quote_line_id(+)
846: AND quote.quote_header_id = p_doc_id;

Line 859: Aso_Quote_Lines_all lines

855: SELECT
856: items.concatenated_segments item
857: FROM
858: Mtl_System_Items_vl items,
859: Aso_Quote_Lines_all lines
860: WHERE
861: lines.inventory_item_id = items.INVENTORY_ITEM_ID
862: AND lines.organization_id = items.organization_id
863: --AND lines.LINE_CATEGORY_CODE = 'ORDER'

Line 872: Aso_Quote_Lines_all lines,

868: SELECT
869: cats.category_concat_segs item_category
870: FROM
871: Mtl_Item_Categories mic,
872: Aso_Quote_Lines_all lines,
873: Mtl_Categories_V cats
874: WHERE
875: lines.inventory_item_id = mic.INVENTORY_ITEM_ID
876: AND mic.category_id = cats.category_id