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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_16 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 (

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,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc

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,base.SERIAL_NUMBER asc,base.CONVERSION_RATE desc
163: ;
164: Elsif (g_serial_control = 1) AND (g_detail_serial = 3) THEN
165: OPEN p_cursor FOR select base.REVISION
166: ,base.LOT_NUMBER

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 mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
253: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
254: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
255: and (

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

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

Line 317: ,WMS_Rule_PVT.GetConversionRate(

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

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

356: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
357: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
358: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
359: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
360: 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
361: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
362: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
363: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
364: and (

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

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

Line 430: ,WMS_Rule_PVT.GetConversionRate(

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

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

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

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

528: )
529: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
530: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
531: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
532: 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: ,base.INVENTORY_ITEM_ID
534: ,base.REVISION
535: ,base.LOT_NUMBER
536: ,base.LOT_EXPIRATION_DATE

Line 554: p_cursor IN WMS_RULE_PVT.cv_pick_type,

550:
551: END open_curs;
552:
553: PROCEDURE fetch_one_row(
554: p_cursor IN WMS_RULE_PVT.cv_pick_type,
555: x_revision OUT NOCOPY VARCHAR2,
556: x_lot_number OUT NOCOPY VARCHAR2,
557: x_lot_expiration_date OUT NOCOPY DATE,
558: x_subinventory_code OUT NOCOPY VARCHAR2,

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

598:
599:
600: END fetch_one_row;
601:
602: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
603: BEGIN
604: if (p_cursor%ISOPEN) THEN
605: CLOSE p_cursor;
606: END IF;

Line 611: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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