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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_4 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 106: ,WMS_Rule_PVT.GetConversionRate(

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

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

146: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
147: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
148: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
149: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
150: 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
151: and msi.ORGANIZATION_ID = base.ORGANIZATION_ID
152: and msi.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
153: and msn.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
154: and msn.SERIAL_NUMBER = base.SERIAL_NUMBER

Line 162: 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,msn.SERIAL_NUMBER asc

158: )
159: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
160: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
161: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
162: 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,msn.SERIAL_NUMBER asc
163: ,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc
164: ;
165: Elsif (g_serial_control = 1) AND (g_detail_serial = 3) THEN
166: OPEN p_cursor FOR select base.REVISION

Line 204: ,WMS_Rule_PVT.GetConversionRate(

200: ,sub.reservable_type
201: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
202: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
203: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
204: ,WMS_Rule_PVT.GetConversionRate(
205: nvl(loc.pick_uom_code, sub.pick_uom_code)
206: ,msn.current_organization_id
207: ,msn.inventory_item_id) conversion_rate
208: ,msn.lpn_id lpn_id

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

247: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
248: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
249: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
250: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
251: 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
252: and msi.ORGANIZATION_ID = base.ORGANIZATION_ID
253: and msi.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
254: and msn.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
255: and msn.SERIAL_NUMBER = base.SERIAL_NUMBER

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

259: )
260: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
261: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
262: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
263: 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
264: ,base.INVENTORY_ITEM_ID
265: ,base.REVISION
266: ,base.LOT_NUMBER
267: ,base.LOT_EXPIRATION_DATE

Line 319: ,WMS_Rule_PVT.GetConversionRate(

315: ,sub.reservable_type
316: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
317: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
318: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
319: ,WMS_Rule_PVT.GetConversionRate(
320: nvl(loc.pick_uom_code, sub.pick_uom_code)
321: ,msn.current_organization_id
322: ,msn.inventory_item_id) conversion_rate
323: ,msn.lpn_id lpn_id

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

358: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
359: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
360: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
361: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
362: 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
363: and msi.ORGANIZATION_ID = base.ORGANIZATION_ID
364: and msi.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
365: and msn.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
366: and msn.SERIAL_NUMBER = base.SERIAL_NUMBER

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

370: )
371: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
372: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
373: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
374: 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
375: ,base.INVENTORY_ITEM_ID
376: ,base.REVISION
377: ,base.LOT_NUMBER
378: ,base.LOT_EXPIRATION_DATE

Line 434: ,WMS_Rule_PVT.GetConversionRate(

430: ,x.reservable_type reservable_type
431: ,x.locreservable locreservable
432: ,x.lotreservable lotreservable
433: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
434: ,WMS_Rule_PVT.GetConversionRate(
435: NVL(loc.pick_uom_code, sub.pick_uom_code)
436: ,x.organization_id
437: ,x.inventory_item_id) conversion_rate
438: ,NULL locator_inventory_item_id

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

521: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
522: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
523: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
524: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
525: 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
526: and msi.ORGANIZATION_ID = base.ORGANIZATION_ID
527: and msi.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
528: and msn.INVENTORY_ITEM_ID = base.INVENTORY_ITEM_ID
529: and msn.SERIAL_NUMBER = base.SERIAL_NUMBER

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

533: )
534: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
535: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
536: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
537: 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
538: ,base.INVENTORY_ITEM_ID
539: ,base.REVISION
540: ,base.LOT_NUMBER
541: ,base.LOT_EXPIRATION_DATE

Line 561: p_cursor IN WMS_RULE_PVT.cv_pick_type,

557:
558: END open_curs;
559:
560: PROCEDURE fetch_one_row(
561: p_cursor IN WMS_RULE_PVT.cv_pick_type,
562: x_revision OUT NOCOPY VARCHAR2,
563: x_lot_number OUT NOCOPY VARCHAR2,
564: x_lot_expiration_date OUT NOCOPY DATE,
565: x_subinventory_code OUT NOCOPY VARCHAR2,

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

605:
606:
607: END fetch_one_row;
608:
609: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
610: BEGIN
611: if (p_cursor%ISOPEN) THEN
612: CLOSE p_cursor;
613: END IF;

Line 618: p_cursor IN WMS_RULE_PVT.cv_pick_type,

614: END close_curs;
615:
616: -- LG convergence new procedure for the new manual picking select screen
617: PROCEDURE fetch_available_rows(
618: p_cursor IN WMS_RULE_PVT.cv_pick_type,
619: x_return_status OUT NOCOPY NUMBER) IS
620:
621: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
622: