[Home] [Help]
700: and ota.transaction_type_id = otl.transaction_type_id
701: and oeh.order_number = mso.segment1
702: and otl.name = mso.segment2
703: and otl.language = (select language_code
704: from fnd_languages
705: where installed_flag = 'B')
706: and mso.sales_order_id = wfs.demand_source_header_id
707: and oel.inventory_item_id = wfs.primary_item_id
708: and rownum = 1;
759: and ota.transaction_type_id = otl.transaction_type_id
760: and oeh.order_number = mso.segment1
761: and otl.name = mso.segment2
762: and otl.language = (select language_code
763: from fnd_languages
764: where installed_flag = 'B')
765: and mso.sales_order_id = mr.demand_source_header_id
766: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
767: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
871: and ota.transaction_type_id = otl.transaction_type_id
872: and oeh.order_number = mso.segment1
873: and otl.name = mso.segment2
874: and otl.language = (select language_code
875: from fnd_languages
876: where installed_flag = 'B')
877: and mso.sales_order_id = mr.demand_source_header_id
878: and mr.demand_source_type_id = decode(oeh.source_document_type_id, 10,
879: INV_RESERVATION_GLOBAL.g_source_type_internal_ord,
1001: and oet.transaction_type_id = oeh.order_type_id
1002: and mso.segment1 = to_char(oeh.order_number)
1003: and mso.segment2 = oet.name
1004: and oet.language = (select language_code
1005: from fnd_languages
1006: where installed_flag = 'B')
1007: and mso.segment3 = lSourceCode
1008: and oel.inventory_item_id = pConfigId
1009: and msi.inventory_item_id = oel.inventory_item_id
5566: /*
5567: commented for reintroduction of bcso
5568: from
5569: mtl_system_items_tl m, -- 2457514
5570: fnd_languages l
5571: where m.inventory_item_id = pModelId
5572: and l.installed_flag In ('I', 'B')
5573: and l.language_code = m.language -- 2457514
5574: and NOT EXISTS
5581: from
5582: -- bugfix 2457514 mtl_system_items_b m, -- Model
5583: mtl_system_items_tl m, -- 2457514
5584: bom_cto_src_orgs bcso,
5585: fnd_languages l
5586: where m.inventory_item_id = pModelId
5587: and bcso.model_item_id = pModelId
5588: and bcso.line_id = pLineId
5589: and m.organization_id = bcso.organization_id
7847: guserid,
7848: mtl_cross.cross_reference_id,
7849: l.language_code,
7850: userenv('lang')
7851: FROM fnd_languages l,
7852: mtl_cross_references_b mtl_cross,
7853: mtl_system_items_tl mtl
7854: WHERE mtl_cross.inventory_item_id = pConfigId
7855: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
9074: from
9075: mtl_parameters mp1,
9076: mtl_system_items_tl m,
9077: bom_cto_src_orgs bcso,
9078: fnd_languages l,
9079: mtl_item_revisions_b mr, --3338108
9080: mtl_parameters mp2 --4109427
9081: where m.inventory_item_id = pModelId
9082: and bcso.model_item_id = m.inventory_item_id