APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1427: from mtl_system_items_kfv

1423:
1424: WriteToLog( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
1425:
1426: select concatenated_segments into v_model_item_name
1427: from mtl_system_items_kfv
1428: where inventory_item_id = pModelId
1429: and rownum = 1 ;
1430:
1431:

Line 1765: from mtl_system_items_kfv

1761: BEGIN
1762:
1763: select substrb(concatenated_segments,1,50)
1764: into v_config
1765: from mtl_system_items_kfv
1766: where organization_id = pOrgId
1767: and inventory_item_id = pConfigId ;
1768: WriteToLog('Config name is.. '|| v_config ,5);
1769:

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

1790: select substrb(msi.concatenated_segments,1,50),
1791: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1792: oeh.order_number
1793: into v_missed_item,v_missed_line_number,v_order_number
1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1795: where msi.organization_id = oel.ship_from_org_id
1796: and msi.inventory_item_id = oel.inventory_item_id
1797: and oel.header_id = oeh.header_id
1798: and oel.line_id = v_missed_line_id;

Line 1812: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1808: select substrb(msi.concatenated_segments,1,50),
1809: 'Not Available' ,
1810: -1
1811: into v_missed_item,v_missed_line_number,v_order_number
1812: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1813: where msi.organization_id = bcolu.ship_from_org_id
1814: and msi.inventory_item_id = bcolu.inventory_item_id
1815: and bcolu.line_id = v_missed_line_id;
1816:

Line 1834: from mtl_system_items_kfv

1830: lStmtNum := 53;
1831: WriteToLog('Select model.. ' ,5);
1832: select substrb(concatenated_segments,1,50)
1833: into v_model
1834: from mtl_system_items_kfv
1835: where organization_id = pOrgId
1836: and inventory_item_id = pModelId ;
1837:
1838: lStmtNum := 54;

Line 5987: from mtl_system_items_kfv

5983: WriteToLog( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
5984:
5985:
5986: select concatenated_segments into v_model_item_name
5987: from mtl_system_items_kfv
5988: where inventory_item_id = pModelId
5989: and rownum = 1 ;
5990:
5991:

Line 6533: from mtl_system_items_kfv

6529: */
6530: END IF;
6531:
6532: select concatenated_segments into v_model_item_name
6533: from mtl_system_items_kfv
6534: where inventory_item_id = pModelId
6535: and rownum = 1 ;
6536:
6537: