DBA Data[Home] [Help]

APPS.WMS_RULE_9 dependencies on WMS_PARAMETER_PVT

Line 173: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

169: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
170: and bmuom.UOM_CLASS = muom.UOM_CLASS
171: and bmuom.BASE_UOM_FLAG = 'Y'
172: and (
173: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
174: base.ORGANIZATION_ID
175: ,base.SUBINVENTORY_CODE
176: ,base.LOCATOR_ID
177: ,mptdtv.INVENTORY_ITEM_ID

Line 200: order by WMS_Parameter_PVT.GetItemOnHand(

196: ,base.CURRENT_CUBIC_AREA
197: ,base.SUGGESTED_CUBIC_AREA
198: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
199: )
200: order by WMS_Parameter_PVT.GetItemOnHand(
201: base.ORGANIZATION_ID
202: ,mptdtv.INVENTORY_ITEM_ID
203: ,base.SUBINVENTORY_CODE
204: ,base.LOCATOR_ID

Line 333: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

329: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
330: and bmuom.UOM_CLASS = muom.UOM_CLASS
331: and bmuom.BASE_UOM_FLAG = 'Y'
332: and (
333: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
334: base.ORGANIZATION_ID
335: ,base.SUBINVENTORY_CODE
336: ,base.LOCATOR_ID
337: ,mptdtv.INVENTORY_ITEM_ID

Line 361: order by WMS_Parameter_PVT.GetItemOnHand(

357: ,base.SUGGESTED_CUBIC_AREA
358: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
359: )
360: and base.subinventory_code = g_subinventory_code
361: order by WMS_Parameter_PVT.GetItemOnHand(
362: base.ORGANIZATION_ID
363: ,mptdtv.INVENTORY_ITEM_ID
364: ,base.SUBINVENTORY_CODE
365: ,base.LOCATOR_ID

Line 492: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

488: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
489: and bmuom.UOM_CLASS = muom.UOM_CLASS
490: and bmuom.BASE_UOM_FLAG = 'Y'
491: and (
492: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
493: base.ORGANIZATION_ID
494: ,base.SUBINVENTORY_CODE
495: ,base.LOCATOR_ID
496: ,mptdtv.INVENTORY_ITEM_ID

Line 521: order by WMS_Parameter_PVT.GetItemOnHand(

517: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
518: )
519: and base.subinventory_code = g_subinventory_code
520: and base.locator_id = g_locator_id
521: order by WMS_Parameter_PVT.GetItemOnHand(
522: base.ORGANIZATION_ID
523: ,mptdtv.INVENTORY_ITEM_ID
524: ,base.SUBINVENTORY_CODE
525: ,base.LOCATOR_ID

Line 657: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

653: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
654: and bmuom.UOM_CLASS = muom.UOM_CLASS
655: and bmuom.BASE_UOM_FLAG = 'Y'
656: and (
657: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
658: base.ORGANIZATION_ID
659: ,base.SUBINVENTORY_CODE
660: ,base.LOCATOR_ID
661: ,mptdtv.INVENTORY_ITEM_ID

Line 684: order by WMS_Parameter_PVT.GetItemOnHand(

680: ,base.CURRENT_CUBIC_AREA
681: ,base.SUGGESTED_CUBIC_AREA
682: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
683: )
684: order by WMS_Parameter_PVT.GetItemOnHand(
685: base.ORGANIZATION_ID
686: ,mptdtv.INVENTORY_ITEM_ID
687: ,base.SUBINVENTORY_CODE
688: ,base.LOCATOR_ID

Line 818: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

814: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
815: and bmuom.UOM_CLASS = muom.UOM_CLASS
816: and bmuom.BASE_UOM_FLAG = 'Y'
817: and (
818: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
819: base.ORGANIZATION_ID
820: ,base.SUBINVENTORY_CODE
821: ,base.LOCATOR_ID
822: ,mptdtv.INVENTORY_ITEM_ID

Line 846: order by WMS_Parameter_PVT.GetItemOnHand(

842: ,base.SUGGESTED_CUBIC_AREA
843: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
844: )
845: and base.subinventory_code = g_subinventory_code
846: order by WMS_Parameter_PVT.GetItemOnHand(
847: base.ORGANIZATION_ID
848: ,mptdtv.INVENTORY_ITEM_ID
849: ,base.SUBINVENTORY_CODE
850: ,base.LOCATOR_ID

Line 981: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

977: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
978: and bmuom.UOM_CLASS = muom.UOM_CLASS
979: and bmuom.BASE_UOM_FLAG = 'Y'
980: and (
981: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
982: base.ORGANIZATION_ID
983: ,base.SUBINVENTORY_CODE
984: ,base.LOCATOR_ID
985: ,mptdtv.INVENTORY_ITEM_ID

Line 1010: order by WMS_Parameter_PVT.GetItemOnHand(

1006: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1007: )
1008: and base.subinventory_code = g_subinventory_code
1009: and base.locator_id = g_locator_id
1010: order by WMS_Parameter_PVT.GetItemOnHand(
1011: base.ORGANIZATION_ID
1012: ,mptdtv.INVENTORY_ITEM_ID
1013: ,base.SUBINVENTORY_CODE
1014: ,base.LOCATOR_ID

Line 1150: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1146: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1147: and bmuom.UOM_CLASS = muom.UOM_CLASS
1148: and bmuom.BASE_UOM_FLAG = 'Y'
1149: and (
1150: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1151: base.ORGANIZATION_ID
1152: ,base.SUBINVENTORY_CODE
1153: ,base.LOCATOR_ID
1154: ,mptdtv.INVENTORY_ITEM_ID

Line 1177: order by WMS_Parameter_PVT.GetItemOnHand(

1173: ,base.CURRENT_CUBIC_AREA
1174: ,base.SUGGESTED_CUBIC_AREA
1175: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1176: )
1177: order by WMS_Parameter_PVT.GetItemOnHand(
1178: base.ORGANIZATION_ID
1179: ,mptdtv.INVENTORY_ITEM_ID
1180: ,base.SUBINVENTORY_CODE
1181: ,base.LOCATOR_ID

Line 1316: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1312: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1313: and bmuom.UOM_CLASS = muom.UOM_CLASS
1314: and bmuom.BASE_UOM_FLAG = 'Y'
1315: and (
1316: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1317: base.ORGANIZATION_ID
1318: ,base.SUBINVENTORY_CODE
1319: ,base.LOCATOR_ID
1320: ,mptdtv.INVENTORY_ITEM_ID

Line 1344: order by WMS_Parameter_PVT.GetItemOnHand(

1340: ,base.SUGGESTED_CUBIC_AREA
1341: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1342: )
1343: and base.subinventory_code = g_subinventory_code
1344: order by WMS_Parameter_PVT.GetItemOnHand(
1345: base.ORGANIZATION_ID
1346: ,mptdtv.INVENTORY_ITEM_ID
1347: ,base.SUBINVENTORY_CODE
1348: ,base.LOCATOR_ID

Line 1483: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1479: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1480: and bmuom.UOM_CLASS = muom.UOM_CLASS
1481: and bmuom.BASE_UOM_FLAG = 'Y'
1482: and (
1483: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1484: base.ORGANIZATION_ID
1485: ,base.SUBINVENTORY_CODE
1486: ,base.LOCATOR_ID
1487: ,mptdtv.INVENTORY_ITEM_ID

Line 1512: order by WMS_Parameter_PVT.GetItemOnHand(

1508: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1509: )
1510: and base.subinventory_code = g_subinventory_code
1511: and base.locator_id = g_locator_id
1512: order by WMS_Parameter_PVT.GetItemOnHand(
1513: base.ORGANIZATION_ID
1514: ,mptdtv.INVENTORY_ITEM_ID
1515: ,base.SUBINVENTORY_CODE
1516: ,base.LOCATOR_ID