DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 873: from mtl_system_items_kfv msi,

869: -1
870: into v_missed_item,
871: v_missed_line_number,
872: v_order_number
873: from mtl_system_items_kfv msi,
874: bom_cto_order_lines bcol
875: where msi.organization_id = bcol.ship_from_org_id
876: and msi.inventory_item_id = bcol.inventory_item_id
877: and bcol.parent_ato_line_id = pLineId

Line 894: from mtl_system_items_kfv msi,

890: oeh.order_number
891: into v_missed_item,
892: v_missed_line_number,
893: v_order_number
894: from mtl_system_items_kfv msi,
895: oe_order_lines_all oel,
896: oe_order_headers_all oeh
897: ,bom_cto_order_lines bcol
898: where msi.organization_id = oel.ship_from_org_id

Line 933: from mtl_system_items_kfv

929: END IF;
930:
931: select substrb(concatenated_segments,1,50)
932: into l_model
933: from mtl_system_items_kfv
934: where organization_id = lNextRec.organization_id
935: and inventory_item_id = pModelId ;
936:
937:

Line 1751: from mtl_system_items_kfv

1747:
1748: if( v_bom_created = 0 and v_config_bom_exists = 0 ) then
1749:
1750: select concatenated_segments into v_model_item_name
1751: from mtl_system_items_kfv
1752: where inventory_item_id = pModelId
1753: and rownum = 1 ;
1754:
1755: