APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1486: from mtl_system_items_kfv

1482:
1483: WriteToLog( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
1484:
1485: select concatenated_segments into v_model_item_name
1486: from mtl_system_items_kfv
1487: where inventory_item_id = pModelId
1488: and rownum = 1 ;
1489:
1490:

Line 1824: from mtl_system_items_kfv

1820: BEGIN
1821:
1822: select substrb(concatenated_segments,1,50)
1823: into v_config
1824: from mtl_system_items_kfv
1825: where organization_id = pOrgId
1826: and inventory_item_id = pConfigId ;
1827: WriteToLog('Config name is.. '|| v_config ,5);
1828:

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

1849: select substrb(msi.concatenated_segments,1,50),
1850: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1851: oeh.order_number
1852: into v_missed_item,v_missed_line_number,v_order_number
1853: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1854: where msi.organization_id = oel.ship_from_org_id
1855: and msi.inventory_item_id = oel.inventory_item_id
1856: and oel.header_id = oeh.header_id
1857: and oel.line_id = v_missed_line_id;

Line 1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1889: /*select substrb(msi.concatenated_segments,1,50),
1890: 'Not Available' ,
1891: -1
1892: into v_missed_item,v_missed_line_number,v_order_number
1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1894: where msi.organization_id = bcolu.ship_from_org_id
1895: and msi.inventory_item_id = bcolu.inventory_item_id
1896: and bcolu.line_id = v_missed_line_id;
1897: */

Line 1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1900: select substrb(msi.concatenated_segments,1,50),
1901: 'Not Available' ,
1902: -1
1903: into v_missed_item,v_missed_line_number,v_order_number
1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1905: where msi.inventory_item_id = bcolu.inventory_item_id
1906: and bcolu.line_id = v_missed_line_id
1907: and rownum = 1;
1908: --End Bugfix 10240482

Line 1923: from mtl_system_items_kfv

1919: lStmtNum := 53;
1920: WriteToLog('Select model.. ' ,5);
1921: select substrb(concatenated_segments,1,50)
1922: into v_model
1923: from mtl_system_items_kfv
1924: where organization_id = pOrgId
1925: and inventory_item_id = pModelId ;
1926:
1927: lStmtNum := 54;

Line 6196: from mtl_system_items_kfv

6192: WriteToLog( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
6193:
6194:
6195: select concatenated_segments into v_model_item_name
6196: from mtl_system_items_kfv
6197: where inventory_item_id = pModelId
6198: and rownum = 1 ;
6199:
6200:

Line 6745: from mtl_system_items_kfv

6741: */
6742: END IF;
6743:
6744: select concatenated_segments into v_model_item_name
6745: from mtl_system_items_kfv
6746: where inventory_item_id = pModelId
6747: and rownum = 1 ;
6748:
6749: