eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVIDIT3 dependencies on MTL_PARAMETERS

Line 325: FROM mtl_parameters

321: SELECT COUNT(1) INTO onhand_master_count
322: FROM mtl_onhand_quantities_detail -- Bug:2687570
323: WHERE inventory_item_id = p_item_id
324: AND (organization_id IN (SELECT organization_id
325: FROM mtl_parameters
326: WHERE master_organization_id = p_master_org))
327: AND ROWNUM = 1;
328:
329: SELECT count(1) INTO material_org_count

Line 379: FROM mtl_parameters

375: SELECT COUNT(1) INTO material_master_count
376: FROM mtl_material_transactions_temp
377: WHERE inventory_item_id = p_item_id
378: AND (organization_id IN (SELECT organization_id
379: FROM mtl_parameters
380: WHERE master_organization_id = p_master_org))
381: AND rownum = 1;
382:
383: --bug 7355994(7356679,7356680): setting lot-serial flag to be 1 in

Line 396: FROM mtl_parameters

392: SELECT COUNT(1) INTO material_master_count
393: FROM mtl_supply ms
394: WHERE ms.item_id = p_item_id
395: AND EXISTS (SELECT 1
396: FROM mtl_parameters
397: WHERE master_organization_id = p_master_org
398: AND (organization_id = ms.from_organization_id OR organization_id = ms.to_organization_id))
399: AND rownum = 1;
400:

Line 409: FROM mtl_parameters

405: INTO material_master_count_ls
406: FROM mtl_supply ms
407: WHERE ms.item_id = p_item_id
408: AND EXISTS (SELECT 1
409: FROM mtl_parameters
410: WHERE master_organization_id = p_master_org
411: AND (organization_id = ms.from_organization_id
412: OR organization_id = ms .to_organization_id))
413: AND supply_type_code in ('RECEIVING', 'SHIPMENT')

Line 423: FROM mtl_parameters

419: SELECT COUNT(1) INTO material_master_count
420: FROM mtl_demand md
421: WHERE md.inventory_item_id = p_item_id
422: AND EXISTS (SELECT 1
423: FROM mtl_parameters
424: WHERE master_organization_id = p_master_org
425: AND organization_id = md.organization_id)
426: AND rownum = 1;
427:

Line 530: from mtl_parameters

526:
527: /* start bug 8406930 */
528: select process_enabled_flag
529: into opm_enabled_org
530: from mtl_parameters
531: where organization_id = p_org_id;
532:
533: if opm_enabled_org ='Y' then -- to check the OPM_ENABLED_ORGS
534:

Line 548: from mtl_parameters

544: into lots_master_count
545: from mtl_lot_numbers mln
546: where inventory_item_id = p_item_id
547: and exists (select 1
548: from mtl_parameters
549: where master_organization_id = p_master_org
550: and organization_id = mln.organization_id)
551: and rownum = 1;
552:

Line 605: from mtl_parameters

601: where supply_type_code = 'SHIPMENT'
602: and item_id = p_item_id
603: and to_organization_id in
604: (select organization_id
605: from mtl_parameters
606: where master_organization_id = p_master_org)
607: and from_organization_id is not null
608: and po_line_location_id is null
609: and rownum = 1;

Line 650: from mtl_parameters

646: where supply_type_code in ('RECEIVING', 'SHIPMENT')
647: and item_id = p_item_id
648: and to_organization_id in
649: (select organization_id
650: from mtl_parameters
651: where master_organization_id = p_master_org)
652: and rownum = 1;
653:
654: end if;

Line 792: from mtl_parameters mp

788: where exists ( select 'x'
789: from mtl_onhand_quantities_detail moh -- Bug:2687570
790: where moh.inventory_item_id = p_item_id
791: and moh.organization_id in ( select mp.organization_id
792: from mtl_parameters mp
793: where mp.master_organization_id = p_master_org));
794: end if;
795:
796: if X_wip_repetitive_item IS NOT NULL THEN

Line 803: from mtl_parameters mp

799: where exists ( select 'x'
800: from WIP_REPETITIVE_ITEMS wri
801: where wri.PRIMARY_ITEM_ID = p_item_id
802: and wri.ORGANIZATION_ID in ( select mp.organization_id
803: from mtl_parameters mp
804: where mp.master_organization_id = p_master_org));
805: end if;
806:
807: IF x_rsv_exists IS NOT NULL THEN

Line 811: mtl_parameters param

807: IF x_rsv_exists IS NOT NULL THEN
808: if (reservable_level = 1) then
809: select count(1) into x_rsv_exists
810: from mtl_reservations res,
811: mtl_parameters param
812: where res.inventory_item_id = p_item_id
813: AND res.organization_id = param.organization_id
814: and param.master_organization_id = p_master_org
815: and reservation_quantity > 0

Line 862: FROM mtl_parameters

858: and ms.shipment_line_id = rsl.shipment_line_id
859: and ms.supply_type_code in ('SHIPMENT', 'RECEIVING'))
860: and rsl.item_id = p_item_id
861: and rsl.from_organization_id IN (SELECT organization_id
862: FROM mtl_parameters
863: WHERE master_organization_id = p_master_org)
864: and rownum = 1;
865: end if;
866:

Line 906: from mtl_parameters

902: and l.open_flag = 'Y'
903: and nvl(l.shipping_interfaced_flag,'N') = 'N'
904: and l.ship_from_org_id in
905: (select organization_id
906: from mtl_parameters
907: where master_organization_id = p_master_org
908: )
909: and rownum = 1;
910: end if;

Line 935: from mtl_parameters

931: --then shippable flag of the item can be modified - Anmurali
932: and wdd.released_status <> 'D'
933: and wdd.source_code = 'OE'
934: and wdd.organization_id in (select organization_id
935: from mtl_parameters
936: where master_organization_id = p_master_org)
937: and rownum = 1;
938: END IF;
939: END IF;

Line 962: from mtl_parameters

958: where l.inventory_item_id = p_item_id
959: and l.open_flag = 'Y' -- Bug 8435071
960: and (l.ship_from_org_id in
961: (select organization_id
962: from mtl_parameters
963: where master_organization_id= p_master_org
964: and 1=transaction_level)
965: or l.ship_from_org_id= p_org_id)
966: and rownum = 1;

Line 1004: from mtl_parameters

1000: and visible_demand_flag = 'Y'
1001: and shipped_quantity is NOT null
1002: and (ship_from_org_id in
1003: (select organization_id
1004: from mtl_parameters
1005: where master_organization_id = p_master_org
1006: and 1=(select control_level
1007: from mtl_item_attributes
1008: where

Line 1092: from mtl_parameters

1088: and bic.component_item_id = p_item_id
1089: and bic.check_atp = 1
1090: and (bom.organization_id in
1091: (select organization_id
1092: from mtl_parameters
1093: where master_organization_id = p_master_org
1094: and 1 = (select control_level
1095: from mtl_item_attributes
1096: where attribute_name= 'MTL_SYSTEM_ITEMS.ATP_FLAG')

Line 1118: from mtl_parameters

1114: ( select 'x' from bom_bill_of_materials bom
1115: where bom.assembly_item_id = p_item_id
1116: and bom.organization_id in
1117: ( select organization_id
1118: from mtl_parameters
1119: where master_organization_id = p_master_org
1120: )
1121: );*/
1122:

Line 1132: from mtl_parameters

1128: ( select 'x' from bom_bill_of_materials bom
1129: where bom.assembly_item_id = p_item_id
1130: and bom.organization_id in
1131: ( select organization_id
1132: from mtl_parameters
1133: where master_organization_id = p_master_org
1134: and 1 = bom_enabled_level
1135: union all
1136: select organization_id

Line 1137: from mtl_parameters

1133: where master_organization_id = p_master_org
1134: and 1 = bom_enabled_level
1135: union all
1136: select organization_id
1137: from mtl_parameters
1138: where organization_id = p_org_id
1139: and 2 = bom_enabled_level
1140: )
1141: );

Line 1163: from mtl_parameters

1159: and sub.component_sequence_id = inv.component_sequence_id
1160: and inv.bill_sequence_id = bom.bill_sequence_id
1161: and bom.organization_id in
1162: (select organization_id
1163: from mtl_parameters
1164: where master_organization_id= p_master_org)
1165: and rownum = 1;
1166:
1167: end if;

Line 1183: from MTL_PARAMETERS

1179: from bom_inventory_components inv, bom_bill_of_materials bom
1180: where inv.component_item_id = p_item_id
1181: and inv.bill_sequence_id=bom.bill_sequence_id
1182: and exists (select count(1)
1183: from MTL_PARAMETERS
1184: WHERE MASTER_ORGANIZATION_ID= p_master_org AND BOM.ORGANIZATION_ID = ORGANIZATION_ID)
1185: and rownum = 1;
1186:
1187: end if;

Line 1231: from mtl_parameters

1227: from mtl_onhand_quantities_detail -- Bug:2687570
1228: where inventory_item_id = p_item_id
1229: and organization_id = p_org_id
1230: /* Bug 14334921 (select organization_id
1231: from mtl_parameters
1232: where cost_organization_id = p_org_id) */
1233: and rownum = 1;
1234:
1235: if (cost_moq <> 1) then

Line 1242: from mtl_parameters

1238: from mtl_onhand_quantities_detail -- Bug:2687570
1239: where inventory_item_id = p_item_id
1240: and organization_id in
1241: (select organization_id
1242: from mtl_parameters
1243: where master_organization_id = p_master_org
1244: and (1=inv_asset_level OR 1=cost_enabled_level))
1245: and rownum = 1;
1246:

Line 1260: from mtl_parameters

1256: from mtl_material_transactions_temp
1257: where inventory_item_id = p_item_id
1258: and organization_id = p_org_id
1259: /* Bug 14334921 (select organization_id
1260: from mtl_parameters
1261: where cost_organization_id = p_org_id)*/
1262: and rownum = 1;
1263:
1264: end if;

Line 1275: from mtl_parameters

1271: from mtl_material_transactions_temp
1272: where inventory_item_id = p_item_id
1273: and organization_id in
1274: (select organization_id
1275: from mtl_parameters
1276: where master_organization_id = p_master_org AND
1277: ( 1=(select control_level from mtl_item_attributes
1278: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')
1279:

Line 1300: from mtl_parameters

1296: from mtl_material_transactions
1297: where inventory_item_id = p_item_id
1298: and organization_id = p_org_id
1299: /* Bug 14334921 (select organization_id
1300: from mtl_parameters
1301: where cost_organization_id = p_org_id)*/
1302: and costed_flag is not null
1303: and rownum = 1;
1304:

Line 1315: from mtl_parameters

1311: from mtl_material_transactions
1312: where inventory_item_id = p_item_id
1313: and organization_id in
1314: (select organization_id
1315: from mtl_parameters
1316: where master_organization_id = p_master_org AND
1317: ( 1=(select control_level from mtl_item_attributes
1318: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')
1319:

Line 1339: from mtl_parameters

1335: where inventory_item_id = p_item_id
1336: and organization_id = p_org_id
1337: and layer_quantity <> 0
1338: and exists (select 1
1339: from mtl_parameters
1340: where organization_id = p_org_id
1341: and primary_cost_method in (2,5,6))
1342: and rownum = 1;
1343:

Line 1355: from mtl_parameters

1351: where inventory_item_id = p_item_id
1352: and layer_quantity <> 0
1353: and organization_id in
1354: (select organization_id
1355: from mtl_parameters
1356: where master_organization_id = p_master_org AND
1357: ( 1=(select control_level from mtl_item_attributes
1358: where attribute_name= 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG')
1359:

Line 1439: from mtl_parameters

1435: -- Check if the item is VMI/Consign enabled
1436: IF X_process_enabled IS NOT NULL THEN
1437: select count(1)
1438: into X_process_enabled
1439: from mtl_parameters
1440: where organization_id = p_org_id
1441: and process_enabled_flag = 'Y'
1442: and rownum = 1;
1443: END IF;