DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_BE_PKG dependencies on MTL_PARAMETERS

Line 193: mtl_parameters mp

189: SELECT 1
190: INTO l_count
191: FROM mtl_system_items_b_kfv msik,
192: mtl_cross_references_vl mcr,
193: mtl_parameters mp
194: WHERE mp.organization_id = msik.organization_id
195: AND msik.inventory_item_id(+) = mcr.inventory_item_id
196: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
197: AND mcr.cross_reference = 'YES'

Line 292: mtl_parameters mp

288: SELECT 1
289: INTO l_count
290: FROM mtl_system_items_b_kfv msik,
291: mtl_cross_references_vl mcr,
292: mtl_parameters mp
293: WHERE mp.organization_id = msik.organization_id
294: AND msik.inventory_item_id(+) = mcr.inventory_item_id
295: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
296: AND mcr.cross_reference = 'YES'

Line 527: mtl_parameters mp

523: SELECT 1
524: INTO l_count1
525: FROM mtl_system_items_b_kfv msik,
526: mtl_cross_references_vl mcr,
527: mtl_parameters mp
528: WHERE mp.organization_id = msik.organization_id
529: AND msik.inventory_item_id(+) = mcr.inventory_item_id
530: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
531: AND mcr.cross_reference = 'YES'

Line 690: mtl_parameters mp

686: SELECT 1
687: INTO l_count2
688: FROM mtl_system_items_b_kfv msik,
689: mtl_cross_references_vl mcr,
690: mtl_parameters mp
691: WHERE mp.organization_id = msik.organization_id
692: AND msik.inventory_item_id(+) = mcr.inventory_item_id
693: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
694: AND mcr.cross_reference = 'YES'

Line 1260: mtl_parameters mp

1256: SELECT 1
1257: INTO l_count
1258: FROM mtl_system_items_b_kfv msik,
1259: mtl_cross_references_vl mcr,
1260: mtl_parameters mp
1261: WHERE mp.organization_id = msik.organization_id
1262: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1263: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
1264: AND mcr.cross_reference = 'YES'

Line 1357: mtl_parameters mp

1353: SELECT 1
1354: INTO l_count
1355: FROM mtl_system_items_b_kfv msik,
1356: mtl_cross_references_vl mcr,
1357: mtl_parameters mp
1358: WHERE mp.organization_id = msik.organization_id
1359: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1360: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
1361: AND mcr.cross_reference = 'YES'

Line 1592: mtl_parameters mp

1588: SELECT 1
1589: INTO l_count1
1590: FROM mtl_system_items_b_kfv msik,
1591: mtl_cross_references_vl mcr,
1592: mtl_parameters mp
1593: WHERE mp.organization_id = msik.organization_id
1594: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1595: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
1596: AND mcr.cross_reference = 'YES'

Line 1755: mtl_parameters mp

1751: SELECT 1
1752: INTO l_count2
1753: FROM mtl_system_items_b_kfv msik,
1754: mtl_cross_references_vl mcr,
1755: mtl_parameters mp
1756: WHERE mp.organization_id = msik.organization_id
1757: AND msik.inventory_item_id(+) = mcr.inventory_item_id
1758: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
1759: AND mcr.cross_reference = 'YES'

Line 2188: mtl_parameters mp

2184: SELECT 1
2185: INTO l_count
2186: FROM mtl_system_items_b_kfv msik,
2187: mtl_cross_references_vl mcr,
2188: mtl_parameters mp
2189: WHERE mp.organization_id = msik.organization_id
2190: AND msik.inventory_item_id(+) = mcr.inventory_item_id
2191: AND mcr.cross_reference_type = 'OPSM INTEGRATED'
2192: AND mcr.cross_reference = 'YES'