APPS.CTO_CONFIG_BOM_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 884: from mtl_system_items_kfv

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

Line 1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1317: select substrb(msi.concatenated_segments,1,50),
1318: 'Not Available' ,
1319: -1
1320: into v_missed_item,v_missed_line_number,v_order_number
1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1322: where msi.organization_id = bcol.ship_from_org_id
1323: and msi.inventory_item_id = bcol.inventory_item_id
1324: and bcol.line_id = v_missed_line_id;
1325:

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

1332: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1333: ||to_char(option_number)),
1334: oeh.order_number
1335: into v_missed_item,v_missed_line_number,v_order_number
1336: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1337: where msi.organization_id = oel.ship_from_org_id
1338: and msi.inventory_item_id = oel.inventory_item_id
1339: and oel.header_id = oeh.header_id
1340: and oel.line_id = v_missed_line_id;

Line 1355: from mtl_system_items_kfv

1351: END IF;
1352:
1353: select substrb(concatenated_segments,1,50)
1354: into v_model
1355: from mtl_system_items_kfv
1356: where organization_id = pOrgId
1357: and inventory_item_id = pModelId ;
1358:
1359: lStmtNum := 54;

Line 4399: from mtl_system_items_kfv

4395: if( v_zero_qty_count > 0 ) then
4396: oe_debug_pub.add( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
4397:
4398: select concatenated_segments into v_model_item_name
4399: from mtl_system_items_kfv
4400: where inventory_item_id = pModelId
4401: and rownum = 1 ;
4402:
4403: l_token1(1).token_name := 'MODEL_NAME';