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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

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

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

147: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
148: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
149: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
150: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
151: 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
152: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
153: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
154: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
155: and ppp.ORGANIZATION_ID (+) = mil.ORGANIZATION_ID

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

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

Line 205: ,WMS_Rule_PVT.GetConversionRate(

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

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

248: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
249: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
250: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
251: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
252: 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
253: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
254: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
255: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
256: and ppp.ORGANIZATION_ID (+) = mil.ORGANIZATION_ID

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

260: )
261: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
262: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
263: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
264: 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
265: ,base.INVENTORY_ITEM_ID
266: ,base.REVISION
267: ,base.LOT_NUMBER
268: ,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 mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
364: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
365: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
366: and ppp.ORGANIZATION_ID (+) = mil.ORGANIZATION_ID

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 433: ,WMS_Rule_PVT.GetConversionRate(

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

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

520: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
521: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
522: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
523: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
524: 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
525: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
526: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
527: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
528: and ppp.ORGANIZATION_ID (+) = mil.ORGANIZATION_ID

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

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

Line 558: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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

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

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

Line 615: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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