eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULE_10 dependencies on WMS_RULE_PVT

Line 4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,

1: PACKAGE BODY WMS_RULE_10 AS
2:
3: PROCEDURE open_curs (
4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,
5: p_organization_id IN NUMBER,
6: p_inventory_item_id IN NUMBER,
7: p_transaction_type_id IN NUMBER,
8: p_subinventory_code IN VARCHAR2,

Line 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

162: and base.INVENTORY_ITEM_ID = g_inventory_item_id
163: and (g_project_id = base.project_id OR base.project_id IS NULL)
164: and (g_task_id = base.task_id OR base.task_id IS NULL)
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

Line 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

291: and base.INVENTORY_ITEM_ID = g_inventory_item_id
292: and (g_project_id = base.project_id OR base.project_id IS NULL)
293: and (g_task_id = base.task_id OR base.task_id IS NULL)
294: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
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(

Line 423: 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

419: and base.INVENTORY_ITEM_ID = g_inventory_item_id
420: and (g_project_id = base.project_id OR base.project_id IS NULL)
421: and (g_task_id = base.task_id OR base.task_id IS NULL)
422: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
423: 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
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

Line 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

553: and base.INVENTORY_ITEM_ID = g_inventory_item_id
554: and (g_project_id = base.project_id OR base.project_id IS NULL)
555: and (g_task_id = base.task_id OR base.task_id IS NULL)
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

Line 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

683: and base.INVENTORY_ITEM_ID = g_inventory_item_id
684: and (g_project_id = base.project_id OR base.project_id IS NULL)
685: and (g_task_id = base.task_id OR base.task_id IS NULL)
686: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
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(

Line 819: 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

815: and base.INVENTORY_ITEM_ID = g_inventory_item_id
816: and (g_project_id = base.project_id OR base.project_id IS NULL)
817: and (g_task_id = base.task_id OR base.task_id IS NULL)
818: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
819: 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
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

Line 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

953: and base.INVENTORY_ITEM_ID = g_inventory_item_id
954: and (g_project_id = base.project_id OR base.project_id IS NULL)
955: and (g_task_id = base.task_id OR base.task_id IS NULL)
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

Line 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

1088: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1089: and (g_project_id = base.project_id OR base.project_id IS NULL)
1090: and (g_task_id = base.task_id OR base.task_id IS NULL)
1091: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
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(

Line 1228: 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

1224: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1225: and (g_project_id = base.project_id OR base.project_id IS NULL)
1226: and (g_task_id = base.task_id OR base.task_id IS NULL)
1227: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1228: 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
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

Line 1251: p_cursor IN WMS_RULE_PVT.cv_put_type,

1247:
1248: END open_curs;
1249:
1250: PROCEDURE fetch_one_row(
1251: p_cursor IN WMS_RULE_PVT.cv_put_type,
1252: x_subinventory_code OUT NOCOPY VARCHAR2,
1253: x_locator_id OUT NOCOPY NUMBER,
1254: x_project_id OUT NOCOPY NUMBER,
1255: x_task_id OUT NOCOPY NUMBER,

Line 1274: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS

1270: end if;
1271:
1272: END fetch_one_row;
1273:
1274: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1275: BEGIN
1276: if p_cursor%ISOPEN then
1277: CLOSE p_cursor;
1278: end if;