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_11 dependencies on WMS_RULE_PVT

Line 4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,

1: PACKAGE BODY WMS_RULE_11 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 169: 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

165: and base.INVENTORY_ITEM_ID = g_inventory_item_id
166: and (g_project_id = base.project_id OR base.project_id IS NULL)
167: and (g_task_id = base.task_id OR base.task_id IS NULL)
168: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
169: 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
170: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
171: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
172: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
173: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

302: and base.INVENTORY_ITEM_ID = g_inventory_item_id
303: and (g_project_id = base.project_id OR base.project_id IS NULL)
304: and (g_task_id = base.task_id OR base.task_id IS NULL)
305: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
306: 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
307: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
308: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
309: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
310: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

438: and base.INVENTORY_ITEM_ID = g_inventory_item_id
439: and (g_project_id = base.project_id OR base.project_id IS NULL)
440: and (g_task_id = base.task_id OR base.task_id IS NULL)
441: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
442: 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
443: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
444: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
445: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
446: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

580: and base.INVENTORY_ITEM_ID = g_inventory_item_id
581: and (g_project_id = base.project_id OR base.project_id IS NULL)
582: and (g_task_id = base.task_id OR base.task_id IS NULL)
583: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
584: 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
585: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
586: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
587: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
588: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

718: and base.INVENTORY_ITEM_ID = g_inventory_item_id
719: and (g_project_id = base.project_id OR base.project_id IS NULL)
720: and (g_task_id = base.task_id OR base.task_id IS NULL)
721: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
722: 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
723: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
724: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
725: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
726: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

858: and base.INVENTORY_ITEM_ID = g_inventory_item_id
859: and (g_project_id = base.project_id OR base.project_id IS NULL)
860: and (g_task_id = base.task_id OR base.task_id IS NULL)
861: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
862: 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
863: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
864: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
865: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
866: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

1004: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1005: and (g_project_id = base.project_id OR base.project_id IS NULL)
1006: and (g_task_id = base.task_id OR base.task_id IS NULL)
1007: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1008: 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
1009: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1010: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1011: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
1012: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

1147: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1148: and (g_project_id = base.project_id OR base.project_id IS NULL)
1149: and (g_task_id = base.task_id OR base.task_id IS NULL)
1150: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1151: 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
1152: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1153: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1154: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
1155: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

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

1291: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1292: and (g_project_id = base.project_id OR base.project_id IS NULL)
1293: and (g_task_id = base.task_id OR base.task_id IS NULL)
1294: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1295: 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
1296: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1297: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1298: and mln.ORGANIZATION_ID (+) = mptdtv.TO_ORGANIZATION_ID
1299: and mln.INVENTORY_ITEM_ID (+) = mptdtv.INVENTORY_ITEM_ID

Line 1323: p_cursor IN WMS_RULE_PVT.cv_put_type,

1319:
1320: END open_curs;
1321:
1322: PROCEDURE fetch_one_row(
1323: p_cursor IN WMS_RULE_PVT.cv_put_type,
1324: x_subinventory_code OUT NOCOPY VARCHAR2,
1325: x_locator_id OUT NOCOPY NUMBER,
1326: x_project_id OUT NOCOPY NUMBER,
1327: x_task_id OUT NOCOPY NUMBER,

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

1342: end if;
1343:
1344: END fetch_one_row;
1345:
1346: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1347: BEGIN
1348: if p_cursor%ISOPEN then
1349: CLOSE p_cursor;
1350: end if;