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.

[Home] [Help]

APPS.WMS_RULE_17 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_17 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 mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
152: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
153: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
154: and (

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

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

Line 201: ,WMS_Rule_PVT.GetConversionRate(

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

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

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

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

254: )
255: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
256: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
257: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
258: 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: ,base.INVENTORY_ITEM_ID
260: ,base.REVISION
261: ,base.LOT_NUMBER
262: ,base.LOT_EXPIRATION_DATE

Line 312: ,WMS_Rule_PVT.GetConversionRate(

308: ,sub.reservable_type
309: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
310: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
311: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
312: ,WMS_Rule_PVT.GetConversionRate(
313: nvl(loc.pick_uom_code, sub.pick_uom_code)
314: ,msn.current_organization_id
315: ,msn.inventory_item_id) conversion_rate
316: ,msn.lpn_id lpn_id

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

351: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
352: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
353: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
354: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
355: 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 mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
357: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
358: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
359: and (

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

361: )
362: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
363: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
364: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
365: 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
366: ,base.INVENTORY_ITEM_ID
367: ,base.REVISION
368: ,base.LOT_NUMBER
369: ,base.LOT_EXPIRATION_DATE

Line 423: ,WMS_Rule_PVT.GetConversionRate(

419: ,x.reservable_type reservable_type
420: ,x.locreservable locreservable
421: ,x.lotreservable lotreservable
422: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
423: ,WMS_Rule_PVT.GetConversionRate(
424: NVL(loc.pick_uom_code, sub.pick_uom_code)
425: ,x.organization_id
426: ,x.inventory_item_id) conversion_rate
427: ,NULL locator_inventory_item_id

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

510: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
511: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
512: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
513: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
514: 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
515: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
516: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
517: and ppovs.PROJECT_ID (+) = mptdtv.PROJECT_ID
518: and (

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

520: )
521: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
522: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
523: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
524: 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
525: ,base.INVENTORY_ITEM_ID
526: ,base.REVISION
527: ,base.LOT_NUMBER
528: ,base.LOT_EXPIRATION_DATE

Line 546: p_cursor IN WMS_RULE_PVT.cv_pick_type,

542:
543: END open_curs;
544:
545: PROCEDURE fetch_one_row(
546: p_cursor IN WMS_RULE_PVT.cv_pick_type,
547: x_revision OUT NOCOPY VARCHAR2,
548: x_lot_number OUT NOCOPY VARCHAR2,
549: x_lot_expiration_date OUT NOCOPY DATE,
550: x_subinventory_code OUT NOCOPY VARCHAR2,

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

590:
591:
592: END fetch_one_row;
593:
594: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
595: BEGIN
596: if (p_cursor%ISOPEN) THEN
597: CLOSE p_cursor;
598: END IF;

Line 603: p_cursor IN WMS_RULE_PVT.cv_pick_type,

599: END close_curs;
600:
601: -- LG convergence new procedure for the new manual picking select screen
602: PROCEDURE fetch_available_rows(
603: p_cursor IN WMS_RULE_PVT.cv_pick_type,
604: x_return_status OUT NOCOPY NUMBER) IS
605:
606: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
607: