APPS.WMS_RULE_10 dependencies on WMS_PARAMETER_PVT

Line 167: order by WMS_Parameter_PVT.GetItemOnHand(

163: and (g_task_id = base.task_id OR base.task_id IS NULL)
164: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
165: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
166: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
167: order by WMS_Parameter_PVT.GetItemOnHand(
168: base.ORGANIZATION_ID
169: ,mptdtv.INVENTORY_ITEM_ID
170: ,base.SUBINVENTORY_CODE
171: ,base.LOCATOR_ID

Line 295: order by WMS_Parameter_PVT.GetItemOnHand(

291: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
292: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
293: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
294: and base.subinventory_code = g_subinventory_code
295: order by WMS_Parameter_PVT.GetItemOnHand(
296: base.ORGANIZATION_ID
297: ,mptdtv.INVENTORY_ITEM_ID
298: ,base.SUBINVENTORY_CODE
299: ,base.LOCATOR_ID

Line 422: order by WMS_Parameter_PVT.GetItemOnHand(

418: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
419: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
420: and base.subinventory_code = g_subinventory_code
421: and base.locator_id = g_locator_id
422: order by WMS_Parameter_PVT.GetItemOnHand(
423: base.ORGANIZATION_ID
424: ,mptdtv.INVENTORY_ITEM_ID
425: ,base.SUBINVENTORY_CODE
426: ,base.LOCATOR_ID

Line 552: order by WMS_Parameter_PVT.GetItemOnHand(

548: and (g_task_id = base.task_id OR base.task_id IS NULL)
549: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
550: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
551: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
552: order by WMS_Parameter_PVT.GetItemOnHand(
553: base.ORGANIZATION_ID
554: ,mptdtv.INVENTORY_ITEM_ID
555: ,base.SUBINVENTORY_CODE
556: ,base.LOCATOR_ID

Line 681: order by WMS_Parameter_PVT.GetItemOnHand(

677: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
678: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
679: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
680: and base.subinventory_code = g_subinventory_code
681: order by WMS_Parameter_PVT.GetItemOnHand(
682: base.ORGANIZATION_ID
683: ,mptdtv.INVENTORY_ITEM_ID
684: ,base.SUBINVENTORY_CODE
685: ,base.LOCATOR_ID

Line 812: order by WMS_Parameter_PVT.GetItemOnHand(

808: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
809: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
810: and base.subinventory_code = g_subinventory_code
811: and base.locator_id = g_locator_id
812: order by WMS_Parameter_PVT.GetItemOnHand(
813: base.ORGANIZATION_ID
814: ,mptdtv.INVENTORY_ITEM_ID
815: ,base.SUBINVENTORY_CODE
816: ,base.LOCATOR_ID

Line 946: order by WMS_Parameter_PVT.GetItemOnHand(

942: and (g_task_id = base.task_id OR base.task_id IS NULL)
943: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
944: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
945: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
946: order by WMS_Parameter_PVT.GetItemOnHand(
947: base.ORGANIZATION_ID
948: ,mptdtv.INVENTORY_ITEM_ID
949: ,base.SUBINVENTORY_CODE
950: ,base.LOCATOR_ID

Line 1080: order by WMS_Parameter_PVT.GetItemOnHand(

1076: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1077: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1078: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1079: and base.subinventory_code = g_subinventory_code
1080: order by WMS_Parameter_PVT.GetItemOnHand(
1081: base.ORGANIZATION_ID
1082: ,mptdtv.INVENTORY_ITEM_ID
1083: ,base.SUBINVENTORY_CODE
1084: ,base.LOCATOR_ID

Line 1215: order by WMS_Parameter_PVT.GetItemOnHand(

1211: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1212: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1213: and base.subinventory_code = g_subinventory_code
1214: and base.locator_id = g_locator_id
1215: order by WMS_Parameter_PVT.GetItemOnHand(
1216: base.ORGANIZATION_ID
1217: ,mptdtv.INVENTORY_ITEM_ID
1218: ,base.SUBINVENTORY_CODE
1219: ,base.LOCATOR_ID