APPS.WMS_RULE_3 dependencies on WMS_PARAMETER_PVT

Line 81: ,WMS_Parameter_PVT.GetItemOnHand(

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

Line 170: ,WMS_Parameter_PVT.GetItemOnHand(

166: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
167: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
168: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
169: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.CONVERSION_RATE desc
170: ,WMS_Parameter_PVT.GetItemOnHand(
171: base.ORGANIZATION_ID
172: ,mptdtv.INVENTORY_ITEM_ID
173: ,base.SUBINVENTORY_CODE
174: ,base.LOCATOR_ID

Line 193: ,WMS_Parameter_PVT.GetItemOnHand(

189: ,sum(base.primary_quantity)
190: ,sum(base.secondary_quantity)
191: ,base.grade_code
192: ,NULL consist_string
193: ,WMS_Parameter_PVT.GetItemOnHand(
194: base.ORGANIZATION_ID
195: ,mptdtv.INVENTORY_ITEM_ID
196: ,base.SUBINVENTORY_CODE
197: ,base.LOCATOR_ID

Line 296: ,WMS_Parameter_PVT.GetItemOnHand(

292: ,base.PROJECT_ID
293: ,base.TASK_ID
294: ,base.UOM_CODE
295: ,base.GRADE_CODE
296: ,WMS_Parameter_PVT.GetItemOnHand(
297: base.ORGANIZATION_ID
298: ,mptdtv.INVENTORY_ITEM_ID
299: ,base.SUBINVENTORY_CODE
300: ,base.LOCATOR_ID

Line 303: ,WMS_Parameter_PVT.GetItemOnHand(

299: ,base.SUBINVENTORY_CODE
300: ,base.LOCATOR_ID
301: ,msi.PRIMARY_UOM_CODE
302: ,mptdtv.TRANSACTION_UOM ),base.SERIAL_NUMBER,base.CONVERSION_RATE
303: ,WMS_Parameter_PVT.GetItemOnHand(
304: base.ORGANIZATION_ID
305: ,mptdtv.INVENTORY_ITEM_ID
306: ,base.SUBINVENTORY_CODE
307: ,base.LOCATOR_ID

Line 311: ,WMS_Parameter_PVT.GetItemOnHand(

307: ,base.LOCATOR_ID
308: ,msi.PRIMARY_UOM_CODE
309: ,mptdtv.TRANSACTION_UOM )
310: order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.CONVERSION_RATE desc
311: ,WMS_Parameter_PVT.GetItemOnHand(
312: base.ORGANIZATION_ID
313: ,mptdtv.INVENTORY_ITEM_ID
314: ,base.SUBINVENTORY_CODE
315: ,base.LOCATOR_ID

Line 334: ,WMS_Parameter_PVT.GetItemOnHand(

330: ,sum(base.primary_quantity)
331: ,sum(base.secondary_quantity)
332: ,base.grade_code
333: ,NULL consist_string
334: ,WMS_Parameter_PVT.GetItemOnHand(
335: base.ORGANIZATION_ID
336: ,mptdtv.INVENTORY_ITEM_ID
337: ,base.SUBINVENTORY_CODE
338: ,base.LOCATOR_ID

Line 433: ,WMS_Parameter_PVT.GetItemOnHand(

429: ,base.PROJECT_ID
430: ,base.TASK_ID
431: ,base.UOM_CODE
432: ,base.GRADE_CODE
433: ,WMS_Parameter_PVT.GetItemOnHand(
434: base.ORGANIZATION_ID
435: ,mptdtv.INVENTORY_ITEM_ID
436: ,base.SUBINVENTORY_CODE
437: ,base.LOCATOR_ID

Line 440: ,WMS_Parameter_PVT.GetItemOnHand(

436: ,base.SUBINVENTORY_CODE
437: ,base.LOCATOR_ID
438: ,msi.PRIMARY_UOM_CODE
439: ,mptdtv.TRANSACTION_UOM ),base.SERIAL_NUMBER,base.CONVERSION_RATE
440: ,WMS_Parameter_PVT.GetItemOnHand(
441: base.ORGANIZATION_ID
442: ,mptdtv.INVENTORY_ITEM_ID
443: ,base.SUBINVENTORY_CODE
444: ,base.LOCATOR_ID

Line 448: ,WMS_Parameter_PVT.GetItemOnHand(

444: ,base.LOCATOR_ID
445: ,msi.PRIMARY_UOM_CODE
446: ,mptdtv.TRANSACTION_UOM )
447: order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.CONVERSION_RATE desc
448: ,WMS_Parameter_PVT.GetItemOnHand(
449: base.ORGANIZATION_ID
450: ,mptdtv.INVENTORY_ITEM_ID
451: ,base.SUBINVENTORY_CODE
452: ,base.LOCATOR_ID

Line 472: ,WMS_Parameter_PVT.GetItemOnHand(

468: ,sum(base.primary_quantity)
469: ,sum(base.secondary_quantity)
470: ,base.grade_code
471: ,NULL consist_string
472: ,WMS_Parameter_PVT.GetItemOnHand(
473: base.ORGANIZATION_ID
474: ,mptdtv.INVENTORY_ITEM_ID
475: ,base.SUBINVENTORY_CODE
476: ,base.LOCATOR_ID

Line 622: ,WMS_Parameter_PVT.GetItemOnHand(

618: ,base.PROJECT_ID
619: ,base.TASK_ID
620: ,base.UOM_CODE
621: ,base.GRADE_CODE
622: ,WMS_Parameter_PVT.GetItemOnHand(
623: base.ORGANIZATION_ID
624: ,mptdtv.INVENTORY_ITEM_ID
625: ,base.SUBINVENTORY_CODE
626: ,base.LOCATOR_ID

Line 629: ,WMS_Parameter_PVT.GetItemOnHand(

625: ,base.SUBINVENTORY_CODE
626: ,base.LOCATOR_ID
627: ,msi.PRIMARY_UOM_CODE
628: ,mptdtv.TRANSACTION_UOM ),base.SERIAL_NUMBER,base.CONVERSION_RATE
629: ,WMS_Parameter_PVT.GetItemOnHand(
630: base.ORGANIZATION_ID
631: ,mptdtv.INVENTORY_ITEM_ID
632: ,base.SUBINVENTORY_CODE
633: ,base.LOCATOR_ID

Line 637: ,WMS_Parameter_PVT.GetItemOnHand(

633: ,base.LOCATOR_ID
634: ,msi.PRIMARY_UOM_CODE
635: ,mptdtv.TRANSACTION_UOM )
636: order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.CONVERSION_RATE desc
637: ,WMS_Parameter_PVT.GetItemOnHand(
638: base.ORGANIZATION_ID
639: ,mptdtv.INVENTORY_ITEM_ID
640: ,base.SUBINVENTORY_CODE
641: ,base.LOCATOR_ID