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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_14 AS
2:
3: PROCEDURE open_curs
4: (
5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,
6: p_organization_id IN NUMBER,
7: p_inventory_item_id IN NUMBER,
8: p_transaction_type_id IN NUMBER,
9: p_revision IN VARCHAR2,

Line 104: ,WMS_Rule_PVT.GetConversionRate(

100: ,sub.reservable_type
101: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
102: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
103: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
104: ,WMS_Rule_PVT.GetConversionRate(
105: nvl(loc.pick_uom_code, sub.pick_uom_code)
106: ,msn.current_organization_id
107: ,msn.inventory_item_id) conversion_rate
108: ,msn.lpn_id lpn_id

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

144: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
145: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
146: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
147: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
148: 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
149: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
150: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
151: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
152: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc

Line 152: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc

148: 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
149: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
150: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
151: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
152: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) order by decode(base.project_id,g_project_id,1,NULL,2,3) asc,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc
153: ;
154: Elsif (g_serial_control = 1) AND (g_detail_serial = 3) THEN
155: OPEN p_cursor FOR select base.REVISION
156: ,base.LOT_NUMBER

Line 191: ,WMS_Rule_PVT.GetConversionRate(

187: ,sub.reservable_type
188: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
189: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
190: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
191: ,WMS_Rule_PVT.GetConversionRate(
192: nvl(loc.pick_uom_code, sub.pick_uom_code)
193: ,msn.current_organization_id
194: ,msn.inventory_item_id) conversion_rate
195: ,msn.lpn_id lpn_id

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

234: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
235: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
236: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
237: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
238: 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
239: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
240: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
241: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
242: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

Line 242: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

238: 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
239: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
240: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
241: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
242: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID
243: ,base.INVENTORY_ITEM_ID
244: ,base.REVISION
245: ,base.LOT_NUMBER
246: ,base.LOT_EXPIRATION_DATE

Line 294: ,WMS_Rule_PVT.GetConversionRate(

290: ,sub.reservable_type
291: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
292: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
293: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
294: ,WMS_Rule_PVT.GetConversionRate(
295: nvl(loc.pick_uom_code, sub.pick_uom_code)
296: ,msn.current_organization_id
297: ,msn.inventory_item_id) conversion_rate
298: ,msn.lpn_id lpn_id

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

333: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
334: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
335: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
336: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
337: 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
338: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
339: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
340: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
341: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

Line 341: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

337: 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
338: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
339: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
340: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
341: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID
342: ,base.INVENTORY_ITEM_ID
343: ,base.REVISION
344: ,base.LOT_NUMBER
345: ,base.LOT_EXPIRATION_DATE

Line 397: ,WMS_Rule_PVT.GetConversionRate(

393: ,x.reservable_type reservable_type
394: ,x.locreservable locreservable
395: ,x.lotreservable lotreservable
396: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
397: ,WMS_Rule_PVT.GetConversionRate(
398: NVL(loc.pick_uom_code, sub.pick_uom_code)
399: ,x.organization_id
400: ,x.inventory_item_id) conversion_rate
401: ,NULL locator_inventory_item_id

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

484: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
485: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
486: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
487: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
488: 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
489: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
490: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
491: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
492: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

Line 492: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID

488: 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
489: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
490: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
491: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
492: and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = 'Y' ) group by base.ORGANIZATION_ID
493: ,base.INVENTORY_ITEM_ID
494: ,base.REVISION
495: ,base.LOT_NUMBER
496: ,base.LOT_EXPIRATION_DATE

Line 514: p_cursor IN WMS_RULE_PVT.cv_pick_type,

510:
511: END open_curs;
512:
513: PROCEDURE fetch_one_row(
514: p_cursor IN WMS_RULE_PVT.cv_pick_type,
515: x_revision OUT NOCOPY VARCHAR2,
516: x_lot_number OUT NOCOPY VARCHAR2,
517: x_lot_expiration_date OUT NOCOPY DATE,
518: x_subinventory_code OUT NOCOPY VARCHAR2,

Line 562: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS

558:
559:
560: END fetch_one_row;
561:
562: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
563: BEGIN
564: if (p_cursor%ISOPEN) THEN
565: CLOSE p_cursor;
566: END IF;

Line 571: p_cursor IN WMS_RULE_PVT.cv_pick_type,

567: END close_curs;
568:
569: -- LG convergence new procedure for the new manual picking select screen
570: PROCEDURE fetch_available_rows(
571: p_cursor IN WMS_RULE_PVT.cv_pick_type,
572: x_return_status OUT NOCOPY NUMBER) IS
573:
574: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
575: