DBA Data[Home] [Help]

APPS.IBE_LEAD_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 454: From aso_quote_lines_all ql, mtl_system_items_kfv msik

450: select ql.quote_header_id, ql.inventory_item_id, ql.organization_id,
451: ql.uom_code, sum(nvl(ql.quantity,0)) quantity,
452: msik.concatenated_segments part_no, msik.description product_description
453: ,ql.line_quote_price line_price , ql.marketing_source_code_id promotion_id
454: From aso_quote_lines_all ql, mtl_system_items_kfv msik
455: Where ql.quote_header_id = p_quote_header_id
456: And ql.inventory_item_id = msik.inventory_item_id
457: And ql.organization_id= msik.organization_id
458: Group by ql.quote_header_id, ql.inventory_item_id, ql.organization_id,

Line 593: From ASO_QUOTE_LINES_ALL QL, MTL_SYSTEM_ITEMS_KFV MSIK

589: select ql.quote_header_id, ql.inventory_item_id, ql.organization_id,
590: ql.uom_code, sum( nvl(ql.quantity, 0)) quantity,
591: msik.concatenated_segments part_no, msik.description product_description
592: ,ql.line_quote_price line_price ,ql.marketing_source_code_id promotion_id
593: From ASO_QUOTE_LINES_ALL QL, MTL_SYSTEM_ITEMS_KFV MSIK
594: Where ql.quote_header_id = p_order_header_id
595: And ql.inventory_item_id = msik.inventory_item_id
596: And ql.organization_id = msik.organization_id
597: Group by ql.quote_header_id, ql.inventory_item_id, ql.organization_id,