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.WMS_RULE_8 dependencies on WMS_PARAMETER_PVT

Line 171: wms_parameter_Pvt.GetNumOtherLots(

167: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
168: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
169: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
170: and (
171: wms_parameter_Pvt.GetNumOtherLots(
172: base.organization_id,
173: base.inventory_item_id,
174: base.subinventory_code,
175: base.locator_id,

Line 177: and wms_parameter_Pvt.GetNumOtherItems(

173: base.inventory_item_id,
174: base.subinventory_code,
175: base.locator_id,
176: mptdtv.lot_number) = 0
177: and wms_parameter_Pvt.GetNumOtherItems(
178: base.organization_id,
179: base.inventory_item_id,
180: base.subinventory_code,
181: base.locator_id) = 0

Line 183: order by WMS_Parameter_PVT.GetItemOnHand(

179: base.inventory_item_id,
180: base.subinventory_code,
181: base.locator_id) = 0
182: )
183: order by WMS_Parameter_PVT.GetItemOnHand(
184: base.ORGANIZATION_ID
185: ,mptdtv.INVENTORY_ITEM_ID
186: ,base.SUBINVENTORY_CODE
187: ,base.LOCATOR_ID

Line 314: wms_parameter_Pvt.GetNumOtherLots(

310: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
311: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
312: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
313: and (
314: wms_parameter_Pvt.GetNumOtherLots(
315: base.organization_id,
316: base.inventory_item_id,
317: base.subinventory_code,
318: base.locator_id,

Line 320: and wms_parameter_Pvt.GetNumOtherItems(

316: base.inventory_item_id,
317: base.subinventory_code,
318: base.locator_id,
319: mptdtv.lot_number) = 0
320: and wms_parameter_Pvt.GetNumOtherItems(
321: base.organization_id,
322: base.inventory_item_id,
323: base.subinventory_code,
324: base.locator_id) = 0

Line 327: order by WMS_Parameter_PVT.GetItemOnHand(

323: base.subinventory_code,
324: base.locator_id) = 0
325: )
326: and base.subinventory_code = g_subinventory_code
327: order by WMS_Parameter_PVT.GetItemOnHand(
328: base.ORGANIZATION_ID
329: ,mptdtv.INVENTORY_ITEM_ID
330: ,base.SUBINVENTORY_CODE
331: ,base.LOCATOR_ID

Line 456: wms_parameter_Pvt.GetNumOtherLots(

452: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
453: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
454: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
455: and (
456: wms_parameter_Pvt.GetNumOtherLots(
457: base.organization_id,
458: base.inventory_item_id,
459: base.subinventory_code,
460: base.locator_id,

Line 462: and wms_parameter_Pvt.GetNumOtherItems(

458: base.inventory_item_id,
459: base.subinventory_code,
460: base.locator_id,
461: mptdtv.lot_number) = 0
462: and wms_parameter_Pvt.GetNumOtherItems(
463: base.organization_id,
464: base.inventory_item_id,
465: base.subinventory_code,
466: base.locator_id) = 0

Line 470: order by WMS_Parameter_PVT.GetItemOnHand(

466: base.locator_id) = 0
467: )
468: and base.subinventory_code = g_subinventory_code
469: and base.locator_id = g_locator_id
470: order by WMS_Parameter_PVT.GetItemOnHand(
471: base.ORGANIZATION_ID
472: ,mptdtv.INVENTORY_ITEM_ID
473: ,base.SUBINVENTORY_CODE
474: ,base.LOCATOR_ID

Line 604: wms_parameter_Pvt.GetNumOtherLots(

600: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
601: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
602: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
603: and (
604: wms_parameter_Pvt.GetNumOtherLots(
605: base.organization_id,
606: base.inventory_item_id,
607: base.subinventory_code,
608: base.locator_id,

Line 610: and wms_parameter_Pvt.GetNumOtherItems(

606: base.inventory_item_id,
607: base.subinventory_code,
608: base.locator_id,
609: mptdtv.lot_number) = 0
610: and wms_parameter_Pvt.GetNumOtherItems(
611: base.organization_id,
612: base.inventory_item_id,
613: base.subinventory_code,
614: base.locator_id) = 0

Line 616: order by WMS_Parameter_PVT.GetItemOnHand(

612: base.inventory_item_id,
613: base.subinventory_code,
614: base.locator_id) = 0
615: )
616: order by WMS_Parameter_PVT.GetItemOnHand(
617: base.ORGANIZATION_ID
618: ,mptdtv.INVENTORY_ITEM_ID
619: ,base.SUBINVENTORY_CODE
620: ,base.LOCATOR_ID

Line 748: wms_parameter_Pvt.GetNumOtherLots(

744: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
745: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
746: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
747: and (
748: wms_parameter_Pvt.GetNumOtherLots(
749: base.organization_id,
750: base.inventory_item_id,
751: base.subinventory_code,
752: base.locator_id,

Line 754: and wms_parameter_Pvt.GetNumOtherItems(

750: base.inventory_item_id,
751: base.subinventory_code,
752: base.locator_id,
753: mptdtv.lot_number) = 0
754: and wms_parameter_Pvt.GetNumOtherItems(
755: base.organization_id,
756: base.inventory_item_id,
757: base.subinventory_code,
758: base.locator_id) = 0

Line 761: order by WMS_Parameter_PVT.GetItemOnHand(

757: base.subinventory_code,
758: base.locator_id) = 0
759: )
760: and base.subinventory_code = g_subinventory_code
761: order by WMS_Parameter_PVT.GetItemOnHand(
762: base.ORGANIZATION_ID
763: ,mptdtv.INVENTORY_ITEM_ID
764: ,base.SUBINVENTORY_CODE
765: ,base.LOCATOR_ID

Line 894: wms_parameter_Pvt.GetNumOtherLots(

890: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
891: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
892: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
893: and (
894: wms_parameter_Pvt.GetNumOtherLots(
895: base.organization_id,
896: base.inventory_item_id,
897: base.subinventory_code,
898: base.locator_id,

Line 900: and wms_parameter_Pvt.GetNumOtherItems(

896: base.inventory_item_id,
897: base.subinventory_code,
898: base.locator_id,
899: mptdtv.lot_number) = 0
900: and wms_parameter_Pvt.GetNumOtherItems(
901: base.organization_id,
902: base.inventory_item_id,
903: base.subinventory_code,
904: base.locator_id) = 0

Line 908: order by WMS_Parameter_PVT.GetItemOnHand(

904: base.locator_id) = 0
905: )
906: and base.subinventory_code = g_subinventory_code
907: and base.locator_id = g_locator_id
908: order by WMS_Parameter_PVT.GetItemOnHand(
909: base.ORGANIZATION_ID
910: ,mptdtv.INVENTORY_ITEM_ID
911: ,base.SUBINVENTORY_CODE
912: ,base.LOCATOR_ID

Line 1046: wms_parameter_Pvt.GetNumOtherLots(

1042: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1043: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1044: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1045: and (
1046: wms_parameter_Pvt.GetNumOtherLots(
1047: base.organization_id,
1048: base.inventory_item_id,
1049: base.subinventory_code,
1050: base.locator_id,

Line 1052: and wms_parameter_Pvt.GetNumOtherItems(

1048: base.inventory_item_id,
1049: base.subinventory_code,
1050: base.locator_id,
1051: mptdtv.lot_number) = 0
1052: and wms_parameter_Pvt.GetNumOtherItems(
1053: base.organization_id,
1054: base.inventory_item_id,
1055: base.subinventory_code,
1056: base.locator_id) = 0

Line 1058: order by WMS_Parameter_PVT.GetItemOnHand(

1054: base.inventory_item_id,
1055: base.subinventory_code,
1056: base.locator_id) = 0
1057: )
1058: order by WMS_Parameter_PVT.GetItemOnHand(
1059: base.ORGANIZATION_ID
1060: ,mptdtv.INVENTORY_ITEM_ID
1061: ,base.SUBINVENTORY_CODE
1062: ,base.LOCATOR_ID

Line 1195: wms_parameter_Pvt.GetNumOtherLots(

1191: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1192: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1193: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1194: and (
1195: wms_parameter_Pvt.GetNumOtherLots(
1196: base.organization_id,
1197: base.inventory_item_id,
1198: base.subinventory_code,
1199: base.locator_id,

Line 1201: and wms_parameter_Pvt.GetNumOtherItems(

1197: base.inventory_item_id,
1198: base.subinventory_code,
1199: base.locator_id,
1200: mptdtv.lot_number) = 0
1201: and wms_parameter_Pvt.GetNumOtherItems(
1202: base.organization_id,
1203: base.inventory_item_id,
1204: base.subinventory_code,
1205: base.locator_id) = 0

Line 1208: order by WMS_Parameter_PVT.GetItemOnHand(

1204: base.subinventory_code,
1205: base.locator_id) = 0
1206: )
1207: and base.subinventory_code = g_subinventory_code
1208: order by WMS_Parameter_PVT.GetItemOnHand(
1209: base.ORGANIZATION_ID
1210: ,mptdtv.INVENTORY_ITEM_ID
1211: ,base.SUBINVENTORY_CODE
1212: ,base.LOCATOR_ID

Line 1345: wms_parameter_Pvt.GetNumOtherLots(

1341: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1342: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1343: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1344: and (
1345: wms_parameter_Pvt.GetNumOtherLots(
1346: base.organization_id,
1347: base.inventory_item_id,
1348: base.subinventory_code,
1349: base.locator_id,

Line 1351: and wms_parameter_Pvt.GetNumOtherItems(

1347: base.inventory_item_id,
1348: base.subinventory_code,
1349: base.locator_id,
1350: mptdtv.lot_number) = 0
1351: and wms_parameter_Pvt.GetNumOtherItems(
1352: base.organization_id,
1353: base.inventory_item_id,
1354: base.subinventory_code,
1355: base.locator_id) = 0

Line 1359: order by WMS_Parameter_PVT.GetItemOnHand(

1355: base.locator_id) = 0
1356: )
1357: and base.subinventory_code = g_subinventory_code
1358: and base.locator_id = g_locator_id
1359: order by WMS_Parameter_PVT.GetItemOnHand(
1360: base.ORGANIZATION_ID
1361: ,mptdtv.INVENTORY_ITEM_ID
1362: ,base.SUBINVENTORY_CODE
1363: ,base.LOCATOR_ID