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 173: wms_parameter_Pvt.GetNumOtherLots(

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

Line 179: and wms_parameter_Pvt.GetNumOtherItems(

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

Line 185: order by WMS_Parameter_PVT.GetItemOnHand(

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

Line 318: wms_parameter_Pvt.GetNumOtherLots(

314: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
315: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
316: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
317: and (
318: wms_parameter_Pvt.GetNumOtherLots(
319: base.organization_id,
320: base.inventory_item_id,
321: base.subinventory_code,
322: base.locator_id,

Line 324: and wms_parameter_Pvt.GetNumOtherItems(

320: base.inventory_item_id,
321: base.subinventory_code,
322: base.locator_id,
323: mptdtv.lot_number) = 0
324: and wms_parameter_Pvt.GetNumOtherItems(
325: base.organization_id,
326: base.inventory_item_id,
327: base.subinventory_code,
328: base.locator_id) = 0

Line 331: order by WMS_Parameter_PVT.GetItemOnHand(

327: base.subinventory_code,
328: base.locator_id) = 0
329: )
330: and base.subinventory_code = g_subinventory_code
331: order by WMS_Parameter_PVT.GetItemOnHand(
332: base.ORGANIZATION_ID
333: ,mptdtv.INVENTORY_ITEM_ID
334: ,base.SUBINVENTORY_CODE
335: ,base.LOCATOR_ID

Line 462: wms_parameter_Pvt.GetNumOtherLots(

458: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
459: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
460: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
461: and (
462: wms_parameter_Pvt.GetNumOtherLots(
463: base.organization_id,
464: base.inventory_item_id,
465: base.subinventory_code,
466: base.locator_id,

Line 468: and wms_parameter_Pvt.GetNumOtherItems(

464: base.inventory_item_id,
465: base.subinventory_code,
466: base.locator_id,
467: mptdtv.lot_number) = 0
468: and wms_parameter_Pvt.GetNumOtherItems(
469: base.organization_id,
470: base.inventory_item_id,
471: base.subinventory_code,
472: base.locator_id) = 0

Line 476: order by WMS_Parameter_PVT.GetItemOnHand(

472: base.locator_id) = 0
473: )
474: and base.subinventory_code = g_subinventory_code
475: and base.locator_id = g_locator_id
476: order by WMS_Parameter_PVT.GetItemOnHand(
477: base.ORGANIZATION_ID
478: ,mptdtv.INVENTORY_ITEM_ID
479: ,base.SUBINVENTORY_CODE
480: ,base.LOCATOR_ID

Line 612: wms_parameter_Pvt.GetNumOtherLots(

608: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
609: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
610: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
611: and (
612: wms_parameter_Pvt.GetNumOtherLots(
613: base.organization_id,
614: base.inventory_item_id,
615: base.subinventory_code,
616: base.locator_id,

Line 618: and wms_parameter_Pvt.GetNumOtherItems(

614: base.inventory_item_id,
615: base.subinventory_code,
616: base.locator_id,
617: mptdtv.lot_number) = 0
618: and wms_parameter_Pvt.GetNumOtherItems(
619: base.organization_id,
620: base.inventory_item_id,
621: base.subinventory_code,
622: base.locator_id) = 0

Line 624: order by WMS_Parameter_PVT.GetItemOnHand(

620: base.inventory_item_id,
621: base.subinventory_code,
622: base.locator_id) = 0
623: )
624: order by WMS_Parameter_PVT.GetItemOnHand(
625: base.ORGANIZATION_ID
626: ,mptdtv.INVENTORY_ITEM_ID
627: ,base.SUBINVENTORY_CODE
628: ,base.LOCATOR_ID

Line 758: wms_parameter_Pvt.GetNumOtherLots(

754: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
755: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
756: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
757: and (
758: wms_parameter_Pvt.GetNumOtherLots(
759: base.organization_id,
760: base.inventory_item_id,
761: base.subinventory_code,
762: base.locator_id,

Line 764: and wms_parameter_Pvt.GetNumOtherItems(

760: base.inventory_item_id,
761: base.subinventory_code,
762: base.locator_id,
763: mptdtv.lot_number) = 0
764: and wms_parameter_Pvt.GetNumOtherItems(
765: base.organization_id,
766: base.inventory_item_id,
767: base.subinventory_code,
768: base.locator_id) = 0

Line 771: order by WMS_Parameter_PVT.GetItemOnHand(

767: base.subinventory_code,
768: base.locator_id) = 0
769: )
770: and base.subinventory_code = g_subinventory_code
771: order by WMS_Parameter_PVT.GetItemOnHand(
772: base.ORGANIZATION_ID
773: ,mptdtv.INVENTORY_ITEM_ID
774: ,base.SUBINVENTORY_CODE
775: ,base.LOCATOR_ID

Line 906: wms_parameter_Pvt.GetNumOtherLots(

902: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
903: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
904: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
905: and (
906: wms_parameter_Pvt.GetNumOtherLots(
907: base.organization_id,
908: base.inventory_item_id,
909: base.subinventory_code,
910: base.locator_id,

Line 912: and wms_parameter_Pvt.GetNumOtherItems(

908: base.inventory_item_id,
909: base.subinventory_code,
910: base.locator_id,
911: mptdtv.lot_number) = 0
912: and wms_parameter_Pvt.GetNumOtherItems(
913: base.organization_id,
914: base.inventory_item_id,
915: base.subinventory_code,
916: base.locator_id) = 0

Line 920: order by WMS_Parameter_PVT.GetItemOnHand(

916: base.locator_id) = 0
917: )
918: and base.subinventory_code = g_subinventory_code
919: and base.locator_id = g_locator_id
920: order by WMS_Parameter_PVT.GetItemOnHand(
921: base.ORGANIZATION_ID
922: ,mptdtv.INVENTORY_ITEM_ID
923: ,base.SUBINVENTORY_CODE
924: ,base.LOCATOR_ID

Line 1060: wms_parameter_Pvt.GetNumOtherLots(

1056: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1057: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1058: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1059: and (
1060: wms_parameter_Pvt.GetNumOtherLots(
1061: base.organization_id,
1062: base.inventory_item_id,
1063: base.subinventory_code,
1064: base.locator_id,

Line 1066: and wms_parameter_Pvt.GetNumOtherItems(

1062: base.inventory_item_id,
1063: base.subinventory_code,
1064: base.locator_id,
1065: mptdtv.lot_number) = 0
1066: and wms_parameter_Pvt.GetNumOtherItems(
1067: base.organization_id,
1068: base.inventory_item_id,
1069: base.subinventory_code,
1070: base.locator_id) = 0

Line 1072: order by WMS_Parameter_PVT.GetItemOnHand(

1068: base.inventory_item_id,
1069: base.subinventory_code,
1070: base.locator_id) = 0
1071: )
1072: order by WMS_Parameter_PVT.GetItemOnHand(
1073: base.ORGANIZATION_ID
1074: ,mptdtv.INVENTORY_ITEM_ID
1075: ,base.SUBINVENTORY_CODE
1076: ,base.LOCATOR_ID

Line 1211: wms_parameter_Pvt.GetNumOtherLots(

1207: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1208: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1209: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1210: and (
1211: wms_parameter_Pvt.GetNumOtherLots(
1212: base.organization_id,
1213: base.inventory_item_id,
1214: base.subinventory_code,
1215: base.locator_id,

Line 1217: and wms_parameter_Pvt.GetNumOtherItems(

1213: base.inventory_item_id,
1214: base.subinventory_code,
1215: base.locator_id,
1216: mptdtv.lot_number) = 0
1217: and wms_parameter_Pvt.GetNumOtherItems(
1218: base.organization_id,
1219: base.inventory_item_id,
1220: base.subinventory_code,
1221: base.locator_id) = 0

Line 1224: order by WMS_Parameter_PVT.GetItemOnHand(

1220: base.subinventory_code,
1221: base.locator_id) = 0
1222: )
1223: and base.subinventory_code = g_subinventory_code
1224: order by WMS_Parameter_PVT.GetItemOnHand(
1225: base.ORGANIZATION_ID
1226: ,mptdtv.INVENTORY_ITEM_ID
1227: ,base.SUBINVENTORY_CODE
1228: ,base.LOCATOR_ID

Line 1363: wms_parameter_Pvt.GetNumOtherLots(

1359: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1360: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1361: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)
1362: and (
1363: wms_parameter_Pvt.GetNumOtherLots(
1364: base.organization_id,
1365: base.inventory_item_id,
1366: base.subinventory_code,
1367: base.locator_id,

Line 1369: and wms_parameter_Pvt.GetNumOtherItems(

1365: base.inventory_item_id,
1366: base.subinventory_code,
1367: base.locator_id,
1368: mptdtv.lot_number) = 0
1369: and wms_parameter_Pvt.GetNumOtherItems(
1370: base.organization_id,
1371: base.inventory_item_id,
1372: base.subinventory_code,
1373: base.locator_id) = 0

Line 1377: order by WMS_Parameter_PVT.GetItemOnHand(

1373: base.locator_id) = 0
1374: )
1375: and base.subinventory_code = g_subinventory_code
1376: and base.locator_id = g_locator_id
1377: order by WMS_Parameter_PVT.GetItemOnHand(
1378: base.ORGANIZATION_ID
1379: ,mptdtv.INVENTORY_ITEM_ID
1380: ,base.SUBINVENTORY_CODE
1381: ,base.LOCATOR_ID