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 311: FROM mtl_parameters

307: SELECT COUNT(1) INTO onhand_master_count
308: FROM mtl_onhand_quantities_detail -- Bug:2687570
309: WHERE inventory_item_id = p_item_id
310: AND (organization_id IN (SELECT organization_id
311: FROM mtl_parameters
312: WHERE master_organization_id = p_master_org))
313: AND ROWNUM = 1;
314:
315: SELECT count(1) INTO material_org_count

Line 365: FROM mtl_parameters

361: SELECT COUNT(1) INTO material_master_count
362: FROM mtl_material_transactions_temp
363: WHERE inventory_item_id = p_item_id
364: AND (organization_id IN (SELECT organization_id
365: FROM mtl_parameters
366: WHERE master_organization_id = p_master_org))
367: AND rownum = 1;
368:
369: --bug 7355994(7356679,7356680): setting lot-serial flag to be 1 in

Line 382: FROM mtl_parameters

378: SELECT COUNT(1) INTO material_master_count
379: FROM mtl_supply ms
380: WHERE ms.item_id = p_item_id
381: AND EXISTS (SELECT 1
382: FROM mtl_parameters
383: WHERE master_organization_id = p_master_org
384: AND (organization_id = ms.from_organization_id OR organization_id = ms.to_organization_id))
385: AND rownum = 1;
386:

Line 395: FROM mtl_parameters

391: INTO material_master_count_ls
392: FROM mtl_supply ms
393: WHERE ms.item_id = p_item_id
394: AND EXISTS (SELECT 1
395: FROM mtl_parameters
396: WHERE master_organization_id = p_master_org
397: AND (organization_id = ms.from_organization_id
398: OR organization_id = ms .to_organization_id))
399: AND supply_type_code in ('RECEIVING', 'SHIPMENT')

Line 409: FROM mtl_parameters

405: SELECT COUNT(1) INTO material_master_count
406: FROM mtl_demand md
407: WHERE md.inventory_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 = md.organization_id)
412: AND rownum = 1;
413:

Line 515: from mtl_parameters

511: into lots_master_count
512: from mtl_lot_numbers mln
513: where inventory_item_id = p_item_id
514: and exists (select 1
515: from mtl_parameters
516: where master_organization_id = p_master_org
517: and organization_id = mln.organization_id)
518: and rownum = 1;
519:

Line 571: from mtl_parameters

567: where supply_type_code = 'SHIPMENT'
568: and item_id = p_item_id
569: and to_organization_id in
570: (select organization_id
571: from mtl_parameters
572: where master_organization_id = p_master_org)
573: and from_organization_id is not null
574: and po_line_location_id is null
575: and rownum = 1;

Line 616: from mtl_parameters

612: where supply_type_code in ('RECEIVING', 'SHIPMENT')
613: and item_id = p_item_id
614: and to_organization_id in
615: (select organization_id
616: from mtl_parameters
617: where master_organization_id = p_master_org)
618: and rownum = 1;
619:
620: end if;

Line 758: from mtl_parameters mp

754: where exists ( select 'x'
755: from mtl_onhand_quantities_detail moh -- Bug:2687570
756: where moh.inventory_item_id = p_item_id
757: and moh.organization_id in ( select mp.organization_id
758: from mtl_parameters mp
759: where mp.master_organization_id = p_master_org));
760: end if;
761:
762: if X_wip_repetitive_item IS NOT NULL THEN

Line 769: from mtl_parameters mp

765: where exists ( select 'x'
766: from WIP_REPETITIVE_ITEMS wri
767: where wri.PRIMARY_ITEM_ID = p_item_id
768: and wri.ORGANIZATION_ID in ( select mp.organization_id
769: from mtl_parameters mp
770: where mp.master_organization_id = p_master_org));
771: end if;
772:
773: IF x_rsv_exists IS NOT NULL THEN

Line 777: mtl_parameters param

773: IF x_rsv_exists IS NOT NULL THEN
774: if (reservable_level = 1) then
775: select count(1) into x_rsv_exists
776: from mtl_reservations res,
777: mtl_parameters param
778: where res.inventory_item_id = p_item_id
779: AND res.organization_id = param.organization_id
780: and param.master_organization_id = p_master_org
781: and reservation_quantity > 0

Line 824: from mtl_parameters

820: and l.open_flag = 'Y'
821: and nvl(l.shipping_interfaced_flag,'N') = 'N'
822: and l.ship_from_org_id in
823: (select organization_id
824: from mtl_parameters
825: where master_organization_id = p_master_org
826: )
827: and rownum = 1;
828: end if;

Line 844: from mtl_parameters

840: and rownum = 1;
841: exception when no_data_found then
842: begin
843: for i in (select organization_id
844: from mtl_parameters
845: where master_organization_id = p_master_org)
846: loop
847: begin
848: select 1 into X_so_ship

Line 890: from mtl_parameters

886: where l.inventory_item_id = p_item_id
887: and l.open_flag || '' = 'Y'
888: and (l.ship_from_org_id in
889: (select organization_id
890: from mtl_parameters
891: where master_organization_id= p_master_org
892: and 1=transaction_level)
893: or l.ship_from_org_id= p_org_id)
894: and rownum = 1;

Line 930: from mtl_parameters

926: and visible_demand_flag = 'Y'
927: and shipped_quantity is NOT null
928: and (ship_from_org_id in
929: (select organization_id
930: from mtl_parameters
931: where master_organization_id = p_master_org
932: and 1=(select control_level
933: from mtl_item_attributes
934: where

Line 1018: from mtl_parameters

1014: and bic.component_item_id = p_item_id
1015: and bic.check_atp = 1
1016: and (bom.organization_id in
1017: (select organization_id
1018: from mtl_parameters
1019: where master_organization_id = p_master_org
1020: and 1 = (select control_level
1021: from mtl_item_attributes
1022: where attribute_name= 'MTL_SYSTEM_ITEMS.ATP_FLAG')

Line 1044: from mtl_parameters

1040: ( select 'x' from bom_bill_of_materials bom
1041: where bom.assembly_item_id = p_item_id
1042: and bom.organization_id in
1043: ( select organization_id
1044: from mtl_parameters
1045: where master_organization_id = p_master_org
1046: )
1047: );*/
1048:

Line 1058: from mtl_parameters

1054: ( select 'x' from bom_bill_of_materials bom
1055: where bom.assembly_item_id = p_item_id
1056: and bom.organization_id in
1057: ( select organization_id
1058: from mtl_parameters
1059: where master_organization_id = p_master_org
1060: and 1 = bom_enabled_level
1061: union all
1062: select organization_id

Line 1063: from mtl_parameters

1059: where master_organization_id = p_master_org
1060: and 1 = bom_enabled_level
1061: union all
1062: select organization_id
1063: from mtl_parameters
1064: where organization_id = p_org_id
1065: and 2 = bom_enabled_level
1066: )
1067: );

Line 1089: from mtl_parameters

1085: and sub.component_sequence_id = inv.component_sequence_id
1086: and inv.bill_sequence_id = bom.bill_sequence_id
1087: and bom.organization_id in
1088: (select organization_id
1089: from mtl_parameters
1090: where master_organization_id= p_master_org)
1091: and rownum = 1;
1092:
1093: end if;

Line 1110: from mtl_parameters

1106: where inv.component_item_id = p_item_id
1107: and inv.bill_sequence_id=bom.bill_sequence_id
1108: and bom.organization_id in
1109: (select organization_id
1110: from mtl_parameters
1111: where master_organization_id= p_master_org)
1112: and rownum = 1;
1113:
1114: end if;

Line 1136: from mtl_parameters

1132: from mtl_onhand_quantities_detail -- Bug:2687570
1133: where inventory_item_id = p_item_id
1134: and organization_id in
1135: (select organization_id
1136: from mtl_parameters
1137: where cost_organization_id = p_org_id)
1138: and rownum = 1;
1139:
1140: if (cost_moq <> 1) then

Line 1147: from mtl_parameters

1143: from mtl_onhand_quantities_detail -- Bug:2687570
1144: where inventory_item_id = p_item_id
1145: and organization_id in
1146: (select organization_id
1147: from mtl_parameters
1148: where master_organization_id = p_master_org
1149: and (1=inv_asset_level OR 1=cost_enabled_level))
1150: and rownum = 1;
1151:

Line 1162: from mtl_parameters

1158: from mtl_material_transactions_temp
1159: where inventory_item_id = p_item_id
1160: and organization_id in
1161: (select organization_id
1162: from mtl_parameters
1163: where cost_organization_id = p_org_id)
1164: and rownum = 1;
1165:
1166: end if;

Line 1176: from mtl_parameters

1172: from mtl_material_transactions
1173: where inventory_item_id = p_item_id
1174: and organization_id in
1175: (select organization_id
1176: from mtl_parameters
1177: where cost_organization_id = p_org_id)
1178: and costed_flag is not null
1179: and rownum = 1;
1180:

Line 1248: from mtl_parameters

1244: -- Check if the item is VMI/Consign enabled
1245: IF X_process_enabled IS NOT NULL THEN
1246: select count(1)
1247: into X_process_enabled
1248: from mtl_parameters
1249: where organization_id = p_org_id
1250: and process_enabled_flag = 'Y'
1251: and rownum = 1;
1252: END IF;