APPS.WMS_RULE_3 dependencies on WMS_PARAMETER_PVT

Line 80: ,WMS_Parameter_PVT.GetItemOnHand(

76: ,base.primary_quantity
77: ,base.secondary_quantity
78: ,base.grade_code
79: ,NULL consist_string
80: ,WMS_Parameter_PVT.GetItemOnHand(
81: base.ORGANIZATION_ID
82: ,mptdtv.INVENTORY_ITEM_ID
83: ,base.SUBINVENTORY_CODE
84: ,base.LOCATOR_ID

Line 165: ,WMS_Parameter_PVT.GetItemOnHand(

161: mln.EXPIRATION_DATE <= sysdate+30
162: and msi.SHELF_LIFE_CODE <> 1
163: )
164: order by base.CONVERSION_RATE desc
165: ,WMS_Parameter_PVT.GetItemOnHand(
166: base.ORGANIZATION_ID
167: ,mptdtv.INVENTORY_ITEM_ID
168: ,base.SUBINVENTORY_CODE
169: ,base.LOCATOR_ID

Line 187: ,WMS_Parameter_PVT.GetItemOnHand(

183: ,sum(base.primary_quantity)
184: ,sum(base.secondary_quantity)
185: ,base.grade_code
186: ,NULL consist_string
187: ,WMS_Parameter_PVT.GetItemOnHand(
188: base.ORGANIZATION_ID
189: ,mptdtv.INVENTORY_ITEM_ID
190: ,base.SUBINVENTORY_CODE
191: ,base.LOCATOR_ID

Line 286: ,WMS_Parameter_PVT.GetItemOnHand(

282: ,base.PROJECT_ID
283: ,base.TASK_ID
284: ,base.UOM_CODE
285: ,base.GRADE_CODE
286: ,WMS_Parameter_PVT.GetItemOnHand(
287: base.ORGANIZATION_ID
288: ,mptdtv.INVENTORY_ITEM_ID
289: ,base.SUBINVENTORY_CODE
290: ,base.LOCATOR_ID

Line 293: ,WMS_Parameter_PVT.GetItemOnHand(

289: ,base.SUBINVENTORY_CODE
290: ,base.LOCATOR_ID
291: ,msi.PRIMARY_UOM_CODE
292: ,mptdtv.TRANSACTION_UOM ),base.CONVERSION_RATE
293: ,WMS_Parameter_PVT.GetItemOnHand(
294: base.ORGANIZATION_ID
295: ,mptdtv.INVENTORY_ITEM_ID
296: ,base.SUBINVENTORY_CODE
297: ,base.LOCATOR_ID

Line 301: ,WMS_Parameter_PVT.GetItemOnHand(

297: ,base.LOCATOR_ID
298: ,msi.PRIMARY_UOM_CODE
299: ,mptdtv.TRANSACTION_UOM )
300: order by base.CONVERSION_RATE desc
301: ,WMS_Parameter_PVT.GetItemOnHand(
302: base.ORGANIZATION_ID
303: ,mptdtv.INVENTORY_ITEM_ID
304: ,base.SUBINVENTORY_CODE
305: ,base.LOCATOR_ID

Line 323: ,WMS_Parameter_PVT.GetItemOnHand(

319: ,sum(base.primary_quantity)
320: ,sum(base.secondary_quantity)
321: ,base.grade_code
322: ,NULL consist_string
323: ,WMS_Parameter_PVT.GetItemOnHand(
324: base.ORGANIZATION_ID
325: ,mptdtv.INVENTORY_ITEM_ID
326: ,base.SUBINVENTORY_CODE
327: ,base.LOCATOR_ID

Line 418: ,WMS_Parameter_PVT.GetItemOnHand(

414: ,base.PROJECT_ID
415: ,base.TASK_ID
416: ,base.UOM_CODE
417: ,base.GRADE_CODE
418: ,WMS_Parameter_PVT.GetItemOnHand(
419: base.ORGANIZATION_ID
420: ,mptdtv.INVENTORY_ITEM_ID
421: ,base.SUBINVENTORY_CODE
422: ,base.LOCATOR_ID

Line 425: ,WMS_Parameter_PVT.GetItemOnHand(

421: ,base.SUBINVENTORY_CODE
422: ,base.LOCATOR_ID
423: ,msi.PRIMARY_UOM_CODE
424: ,mptdtv.TRANSACTION_UOM ),base.CONVERSION_RATE
425: ,WMS_Parameter_PVT.GetItemOnHand(
426: base.ORGANIZATION_ID
427: ,mptdtv.INVENTORY_ITEM_ID
428: ,base.SUBINVENTORY_CODE
429: ,base.LOCATOR_ID

Line 433: ,WMS_Parameter_PVT.GetItemOnHand(

429: ,base.LOCATOR_ID
430: ,msi.PRIMARY_UOM_CODE
431: ,mptdtv.TRANSACTION_UOM )
432: order by base.CONVERSION_RATE desc
433: ,WMS_Parameter_PVT.GetItemOnHand(
434: base.ORGANIZATION_ID
435: ,mptdtv.INVENTORY_ITEM_ID
436: ,base.SUBINVENTORY_CODE
437: ,base.LOCATOR_ID

Line 456: ,WMS_Parameter_PVT.GetItemOnHand(

452: ,sum(base.primary_quantity)
453: ,sum(base.secondary_quantity)
454: ,base.grade_code
455: ,NULL consist_string
456: ,WMS_Parameter_PVT.GetItemOnHand(
457: base.ORGANIZATION_ID
458: ,mptdtv.INVENTORY_ITEM_ID
459: ,base.SUBINVENTORY_CODE
460: ,base.LOCATOR_ID

Line 598: ,WMS_Parameter_PVT.GetItemOnHand(

594: ,base.PROJECT_ID
595: ,base.TASK_ID
596: ,base.UOM_CODE
597: ,base.GRADE_CODE
598: ,WMS_Parameter_PVT.GetItemOnHand(
599: base.ORGANIZATION_ID
600: ,mptdtv.INVENTORY_ITEM_ID
601: ,base.SUBINVENTORY_CODE
602: ,base.LOCATOR_ID

Line 605: ,WMS_Parameter_PVT.GetItemOnHand(

601: ,base.SUBINVENTORY_CODE
602: ,base.LOCATOR_ID
603: ,msi.PRIMARY_UOM_CODE
604: ,mptdtv.TRANSACTION_UOM ),base.CONVERSION_RATE
605: ,WMS_Parameter_PVT.GetItemOnHand(
606: base.ORGANIZATION_ID
607: ,mptdtv.INVENTORY_ITEM_ID
608: ,base.SUBINVENTORY_CODE
609: ,base.LOCATOR_ID

Line 613: ,WMS_Parameter_PVT.GetItemOnHand(

609: ,base.LOCATOR_ID
610: ,msi.PRIMARY_UOM_CODE
611: ,mptdtv.TRANSACTION_UOM )
612: order by base.CONVERSION_RATE desc
613: ,WMS_Parameter_PVT.GetItemOnHand(
614: base.ORGANIZATION_ID
615: ,mptdtv.INVENTORY_ITEM_ID
616: ,base.SUBINVENTORY_CODE
617: ,base.LOCATOR_ID