APPS.CTO_CONFIG_BOM_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 882: from mtl_system_items_kfv

878:
879: oe_debug_pub.add( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
880:
881: select concatenated_segments into v_model_item_name
882: from mtl_system_items_kfv
883: where inventory_item_id = pModelId
884: and rownum = 1 ;
885:
886:

Line 1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1291: select substrb(msi.concatenated_segments,1,50),
1292: 'Not Available' ,
1293: -1
1294: into v_missed_item,v_missed_line_number,v_order_number
1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1296: where msi.organization_id = bcol.ship_from_org_id
1297: and msi.inventory_item_id = bcol.inventory_item_id
1298: and bcol.line_id = v_missed_line_id;
1299:

Line 1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh

1306: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1307: ||to_char(option_number)),
1308: oeh.order_number
1309: into v_missed_item,v_missed_line_number,v_order_number
1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1311: where msi.organization_id = oel.ship_from_org_id
1312: and msi.inventory_item_id = oel.inventory_item_id
1313: and oel.header_id = oeh.header_id
1314: and oel.line_id = v_missed_line_id;

Line 1329: from mtl_system_items_kfv

1325: END IF;
1326:
1327: select substrb(concatenated_segments,1,50)
1328: into v_model
1329: from mtl_system_items_kfv
1330: where organization_id = pOrgId
1331: and inventory_item_id = pModelId ;
1332:
1333: lStmtNum := 54;

Line 4225: from mtl_system_items_kfv

4221: oe_debug_pub.add( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
4222:
4223:
4224: select concatenated_segments into v_model_item_name
4225: from mtl_system_items_kfv
4226: where inventory_item_id = pModelId
4227: and rownum = 1 ;
4228:
4229: