DBA Data[Home] [Help]

APPS.WMS_RULE_9 dependencies on WMS_PARAMETER_PVT

Line 175: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

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

Line 202: order by WMS_Parameter_PVT.GetItemOnHand(

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

Line 337: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

333: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
334: and bmuom.UOM_CLASS = muom.UOM_CLASS
335: and bmuom.BASE_UOM_FLAG = 'Y'
336: and (
337: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
338: base.ORGANIZATION_ID
339: ,base.SUBINVENTORY_CODE
340: ,base.LOCATOR_ID
341: ,mptdtv.INVENTORY_ITEM_ID

Line 365: order by WMS_Parameter_PVT.GetItemOnHand(

361: ,base.SUGGESTED_CUBIC_AREA
362: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
363: )
364: and base.subinventory_code = g_subinventory_code
365: order by WMS_Parameter_PVT.GetItemOnHand(
366: base.ORGANIZATION_ID
367: ,mptdtv.INVENTORY_ITEM_ID
368: ,base.SUBINVENTORY_CODE
369: ,base.LOCATOR_ID

Line 498: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

494: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
495: and bmuom.UOM_CLASS = muom.UOM_CLASS
496: and bmuom.BASE_UOM_FLAG = 'Y'
497: and (
498: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
499: base.ORGANIZATION_ID
500: ,base.SUBINVENTORY_CODE
501: ,base.LOCATOR_ID
502: ,mptdtv.INVENTORY_ITEM_ID

Line 527: order by WMS_Parameter_PVT.GetItemOnHand(

523: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
524: )
525: and base.subinventory_code = g_subinventory_code
526: and base.locator_id = g_locator_id
527: order by WMS_Parameter_PVT.GetItemOnHand(
528: base.ORGANIZATION_ID
529: ,mptdtv.INVENTORY_ITEM_ID
530: ,base.SUBINVENTORY_CODE
531: ,base.LOCATOR_ID

Line 665: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

661: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
662: and bmuom.UOM_CLASS = muom.UOM_CLASS
663: and bmuom.BASE_UOM_FLAG = 'Y'
664: and (
665: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
666: base.ORGANIZATION_ID
667: ,base.SUBINVENTORY_CODE
668: ,base.LOCATOR_ID
669: ,mptdtv.INVENTORY_ITEM_ID

Line 692: order by WMS_Parameter_PVT.GetItemOnHand(

688: ,base.CURRENT_CUBIC_AREA
689: ,base.SUGGESTED_CUBIC_AREA
690: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
691: )
692: order by WMS_Parameter_PVT.GetItemOnHand(
693: base.ORGANIZATION_ID
694: ,mptdtv.INVENTORY_ITEM_ID
695: ,base.SUBINVENTORY_CODE
696: ,base.LOCATOR_ID

Line 828: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

824: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
825: and bmuom.UOM_CLASS = muom.UOM_CLASS
826: and bmuom.BASE_UOM_FLAG = 'Y'
827: and (
828: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
829: base.ORGANIZATION_ID
830: ,base.SUBINVENTORY_CODE
831: ,base.LOCATOR_ID
832: ,mptdtv.INVENTORY_ITEM_ID

Line 856: order by WMS_Parameter_PVT.GetItemOnHand(

852: ,base.SUGGESTED_CUBIC_AREA
853: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
854: )
855: and base.subinventory_code = g_subinventory_code
856: order by WMS_Parameter_PVT.GetItemOnHand(
857: base.ORGANIZATION_ID
858: ,mptdtv.INVENTORY_ITEM_ID
859: ,base.SUBINVENTORY_CODE
860: ,base.LOCATOR_ID

Line 993: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

989: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
990: and bmuom.UOM_CLASS = muom.UOM_CLASS
991: and bmuom.BASE_UOM_FLAG = 'Y'
992: and (
993: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
994: base.ORGANIZATION_ID
995: ,base.SUBINVENTORY_CODE
996: ,base.LOCATOR_ID
997: ,mptdtv.INVENTORY_ITEM_ID

Line 1022: order by WMS_Parameter_PVT.GetItemOnHand(

1018: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1019: )
1020: and base.subinventory_code = g_subinventory_code
1021: and base.locator_id = g_locator_id
1022: order by WMS_Parameter_PVT.GetItemOnHand(
1023: base.ORGANIZATION_ID
1024: ,mptdtv.INVENTORY_ITEM_ID
1025: ,base.SUBINVENTORY_CODE
1026: ,base.LOCATOR_ID

Line 1164: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1160: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1161: and bmuom.UOM_CLASS = muom.UOM_CLASS
1162: and bmuom.BASE_UOM_FLAG = 'Y'
1163: and (
1164: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1165: base.ORGANIZATION_ID
1166: ,base.SUBINVENTORY_CODE
1167: ,base.LOCATOR_ID
1168: ,mptdtv.INVENTORY_ITEM_ID

Line 1191: order by WMS_Parameter_PVT.GetItemOnHand(

1187: ,base.CURRENT_CUBIC_AREA
1188: ,base.SUGGESTED_CUBIC_AREA
1189: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1190: )
1191: order by WMS_Parameter_PVT.GetItemOnHand(
1192: base.ORGANIZATION_ID
1193: ,mptdtv.INVENTORY_ITEM_ID
1194: ,base.SUBINVENTORY_CODE
1195: ,base.LOCATOR_ID

Line 1332: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1328: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1329: and bmuom.UOM_CLASS = muom.UOM_CLASS
1330: and bmuom.BASE_UOM_FLAG = 'Y'
1331: and (
1332: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1333: base.ORGANIZATION_ID
1334: ,base.SUBINVENTORY_CODE
1335: ,base.LOCATOR_ID
1336: ,mptdtv.INVENTORY_ITEM_ID

Line 1360: order by WMS_Parameter_PVT.GetItemOnHand(

1356: ,base.SUGGESTED_CUBIC_AREA
1357: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1358: )
1359: and base.subinventory_code = g_subinventory_code
1360: order by WMS_Parameter_PVT.GetItemOnHand(
1361: base.ORGANIZATION_ID
1362: ,mptdtv.INVENTORY_ITEM_ID
1363: ,base.SUBINVENTORY_CODE
1364: ,base.LOCATOR_ID

Line 1501: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (

1497: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1498: and bmuom.UOM_CLASS = muom.UOM_CLASS
1499: and bmuom.BASE_UOM_FLAG = 'Y'
1500: and (
1501: WMS_Parameter_PVT.GetMinimumAvailableUVWCapacity (
1502: base.ORGANIZATION_ID
1503: ,base.SUBINVENTORY_CODE
1504: ,base.LOCATOR_ID
1505: ,mptdtv.INVENTORY_ITEM_ID

Line 1530: order by WMS_Parameter_PVT.GetItemOnHand(

1526: ,base.AVAILABLE_CUBIC_AREA ) >= mptdtv.PRIMARY_QUANTITY
1527: )
1528: and base.subinventory_code = g_subinventory_code
1529: and base.locator_id = g_locator_id
1530: order by WMS_Parameter_PVT.GetItemOnHand(
1531: base.ORGANIZATION_ID
1532: ,mptdtv.INVENTORY_ITEM_ID
1533: ,base.SUBINVENTORY_CODE
1534: ,base.LOCATOR_ID