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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_2 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.DATE_RECEIVED 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.DATE_RECEIVED 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.DATE_RECEIVED desc
153: ,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc
154: ;
155: Elsif (g_serial_control = 1) AND (g_detail_serial = 3) THEN
156: OPEN p_cursor FOR select base.REVISION

Line 192: ,WMS_Rule_PVT.GetConversionRate(

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

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

235: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
236: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
237: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
238: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
239: 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
240: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
241: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
242: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
243: 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 243: 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

239: 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
240: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
241: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
242: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
243: 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
244: ,base.INVENTORY_ITEM_ID
245: ,base.REVISION
246: ,base.LOT_NUMBER
247: ,base.LOT_EXPIRATION_DATE

Line 297: ,WMS_Rule_PVT.GetConversionRate(

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

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

336: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
337: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
338: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
339: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
340: 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
341: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
342: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
343: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
344: 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 344: 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

340: 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
341: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
342: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
343: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
344: 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
345: ,base.INVENTORY_ITEM_ID
346: ,base.REVISION
347: ,base.LOT_NUMBER
348: ,base.LOT_EXPIRATION_DATE

Line 402: ,WMS_Rule_PVT.GetConversionRate(

398: ,x.reservable_type reservable_type
399: ,x.locreservable locreservable
400: ,x.lotreservable lotreservable
401: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
402: ,WMS_Rule_PVT.GetConversionRate(
403: NVL(loc.pick_uom_code, sub.pick_uom_code)
404: ,x.organization_id
405: ,x.inventory_item_id) conversion_rate
406: ,NULL locator_inventory_item_id

Line 493: 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 decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
490: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
491: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
492: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
493: 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
494: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
495: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
496: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
497: 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 497: 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: 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
494: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
495: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
496: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
497: 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
498: ,base.INVENTORY_ITEM_ID
499: ,base.REVISION
500: ,base.LOT_NUMBER
501: ,base.LOT_EXPIRATION_DATE

Line 521: p_cursor IN WMS_RULE_PVT.cv_pick_type,

517:
518: END open_curs;
519:
520: PROCEDURE fetch_one_row(
521: p_cursor IN WMS_RULE_PVT.cv_pick_type,
522: x_revision OUT NOCOPY VARCHAR2,
523: x_lot_number OUT NOCOPY VARCHAR2,
524: x_lot_expiration_date OUT NOCOPY DATE,
525: x_subinventory_code OUT NOCOPY VARCHAR2,

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

565:
566:
567: END fetch_one_row;
568:
569: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
570: BEGIN
571: if (p_cursor%ISOPEN) THEN
572: CLOSE p_cursor;
573: END IF;

Line 578: p_cursor IN WMS_RULE_PVT.cv_pick_type,

574: END close_curs;
575:
576: -- LG convergence new procedure for the new manual picking select screen
577: PROCEDURE fetch_available_rows(
578: p_cursor IN WMS_RULE_PVT.cv_pick_type,
579: x_return_status OUT NOCOPY NUMBER) IS
580:
581: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
582: