DBA Data[Home] [Help]

APPS.WMS_RULE_10 dependencies on WMS_PARAMETER_PVT

Line 169: order by WMS_Parameter_PVT.GetItemOnHand(

165: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
166: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
167: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
168: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
169: order by WMS_Parameter_PVT.GetItemOnHand(
170: base.ORGANIZATION_ID
171: ,mptdtv.INVENTORY_ITEM_ID
172: ,base.SUBINVENTORY_CODE
173: ,base.LOCATOR_ID

Line 299: order by WMS_Parameter_PVT.GetItemOnHand(

295: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
296: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
297: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
298: and base.subinventory_code = g_subinventory_code
299: order by WMS_Parameter_PVT.GetItemOnHand(
300: base.ORGANIZATION_ID
301: ,mptdtv.INVENTORY_ITEM_ID
302: ,base.SUBINVENTORY_CODE
303: ,base.LOCATOR_ID

Line 428: order by WMS_Parameter_PVT.GetItemOnHand(

424: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
425: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
426: and base.subinventory_code = g_subinventory_code
427: and base.locator_id = g_locator_id
428: order by WMS_Parameter_PVT.GetItemOnHand(
429: base.ORGANIZATION_ID
430: ,mptdtv.INVENTORY_ITEM_ID
431: ,base.SUBINVENTORY_CODE
432: ,base.LOCATOR_ID

Line 560: order by WMS_Parameter_PVT.GetItemOnHand(

556: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
557: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
558: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
559: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
560: order by WMS_Parameter_PVT.GetItemOnHand(
561: base.ORGANIZATION_ID
562: ,mptdtv.INVENTORY_ITEM_ID
563: ,base.SUBINVENTORY_CODE
564: ,base.LOCATOR_ID

Line 691: order by WMS_Parameter_PVT.GetItemOnHand(

687: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
688: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
689: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
690: and base.subinventory_code = g_subinventory_code
691: order by WMS_Parameter_PVT.GetItemOnHand(
692: base.ORGANIZATION_ID
693: ,mptdtv.INVENTORY_ITEM_ID
694: ,base.SUBINVENTORY_CODE
695: ,base.LOCATOR_ID

Line 824: order by WMS_Parameter_PVT.GetItemOnHand(

820: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
821: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
822: and base.subinventory_code = g_subinventory_code
823: and base.locator_id = g_locator_id
824: order by WMS_Parameter_PVT.GetItemOnHand(
825: base.ORGANIZATION_ID
826: ,mptdtv.INVENTORY_ITEM_ID
827: ,base.SUBINVENTORY_CODE
828: ,base.LOCATOR_ID

Line 960: order by WMS_Parameter_PVT.GetItemOnHand(

956: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
957: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
958: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
959: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
960: order by WMS_Parameter_PVT.GetItemOnHand(
961: base.ORGANIZATION_ID
962: ,mptdtv.INVENTORY_ITEM_ID
963: ,base.SUBINVENTORY_CODE
964: ,base.LOCATOR_ID

Line 1096: order by WMS_Parameter_PVT.GetItemOnHand(

1092: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
1093: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1094: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1095: and base.subinventory_code = g_subinventory_code
1096: order by WMS_Parameter_PVT.GetItemOnHand(
1097: base.ORGANIZATION_ID
1098: ,mptdtv.INVENTORY_ITEM_ID
1099: ,base.SUBINVENTORY_CODE
1100: ,base.LOCATOR_ID

Line 1233: order by WMS_Parameter_PVT.GetItemOnHand(

1229: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1230: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1231: and base.subinventory_code = g_subinventory_code
1232: and base.locator_id = g_locator_id
1233: order by WMS_Parameter_PVT.GetItemOnHand(
1234: base.ORGANIZATION_ID
1235: ,mptdtv.INVENTORY_ITEM_ID
1236: ,base.SUBINVENTORY_CODE
1237: ,base.LOCATOR_ID