[Home] [Help]
775: and ota.transaction_type_id = otl.transaction_type_id
776: and oeh.order_number = mso.segment1
777: and otl.name = mso.segment2
778: and otl.language = (select language_code
779: from fnd_languages
780: where installed_flag = 'B')
781: and mso.sales_order_id = wfs.demand_source_header_id
782: and oel.inventory_item_id = wfs.primary_item_id
783: and rownum = 1;
834: and ota.transaction_type_id = otl.transaction_type_id
835: and oeh.order_number = mso.segment1
836: and otl.name = mso.segment2
837: and otl.language = (select language_code
838: from fnd_languages
839: where installed_flag = 'B')
840: and mso.sales_order_id = mr.demand_source_header_id
841: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
842: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
946: and ota.transaction_type_id = otl.transaction_type_id
947: and oeh.order_number = mso.segment1
948: and otl.name = mso.segment2
949: and otl.language = (select language_code
950: from fnd_languages
951: where installed_flag = 'B')
952: and mso.sales_order_id = mr.demand_source_header_id
953: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
954: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1080: and oet.transaction_type_id = oeh.order_type_id
1081: and mso.segment1 = to_char(oeh.order_number)
1082: and mso.segment2 = oet.name
1083: and oet.language = (select language_code
1084: from fnd_languages
1085: where installed_flag = 'B')
1086: and mso.segment3 = lSourceCode
1087: and oel.inventory_item_id = pConfigId
1088: and msi.inventory_item_id = oel.inventory_item_id
5723: /*
5724: commented for reintroduction of bcso
5725: from
5726: mtl_system_items_tl m, -- 2457514
5727: fnd_languages l
5728: where m.inventory_item_id = pModelId
5729: and l.installed_flag In ('I', 'B')
5730: and l.language_code = m.language -- 2457514
5731: and NOT EXISTS
5738: from
5739: -- bugfix 2457514 mtl_system_items_b m, -- Model
5740: mtl_system_items_tl m, -- 2457514
5741: bom_cto_src_orgs bcso,
5742: fnd_languages l
5743: where
5744: --m.inventory_item_id = pModelId -- bugfix 12809414
5745: m.inventory_item_id = bcso.model_item_id
5746: and bcso.model_item_id = pModelId
8032: guserid,
8033: mtl_cross.cross_reference_id,
8034: l.language_code,
8035: userenv('lang')
8036: FROM fnd_languages l,
8037: mtl_cross_references_b mtl_cross,
8038: mtl_system_items_tl mtl
8039: WHERE mtl_cross.inventory_item_id = pConfigId
8040: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
9375: from
9376: mtl_parameters mp1,
9377: mtl_system_items_tl m,
9378: bom_cto_src_orgs bcso,
9379: fnd_languages l,
9380: mtl_item_revisions_b mr, --3338108
9381: mtl_parameters mp2 --4109427
9382: where m.inventory_item_id = pModelId
9383: and bcso.model_item_id = m.inventory_item_id