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

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

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

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

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

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

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

Line 198: ,WMS_Rule_PVT.GetConversionRate(

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

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

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

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

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

Line 307: ,WMS_Rule_PVT.GetConversionRate(

303: ,sub.reservable_type
304: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
305: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
306: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
307: ,WMS_Rule_PVT.GetConversionRate(
308: nvl(loc.pick_uom_code, sub.pick_uom_code)
309: ,msn.current_organization_id
310: ,msn.inventory_item_id) conversion_rate
311: ,msn.lpn_id lpn_id

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

346: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
347: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
348: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
349: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
350: 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 mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
352: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
353: and (
354: mil.PROJECT_ID IS NULL

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

355: )
356: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
357: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
358: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
359: 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
360: ,base.INVENTORY_ITEM_ID
361: ,base.REVISION
362: ,base.LOT_NUMBER
363: ,base.LOT_EXPIRATION_DATE

Line 416: ,WMS_Rule_PVT.GetConversionRate(

412: ,x.reservable_type reservable_type
413: ,x.locreservable locreservable
414: ,x.lotreservable lotreservable
415: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
416: ,WMS_Rule_PVT.GetConversionRate(
417: NVL(loc.pick_uom_code, sub.pick_uom_code)
418: ,x.organization_id
419: ,x.inventory_item_id) conversion_rate
420: ,NULL locator_inventory_item_id

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

503: and decode(g_lot_number, '-9999', 'a', base.LOT_NUMBER) = decode(g_lot_number, '-9999', 'a', g_lot_number)
504: and decode(g_lpn_id, -9999, 1, base.lpn_id) = decode(g_lpn_id, -9999, 1, g_lpn_id)
505: and decode(g_cost_group_id, -9999, 1, base.cost_group_id) = decode(g_cost_group_id, -9999, 1, g_cost_group_id)
506: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
507: 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
508: and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
509: and mil.INVENTORY_LOCATION_ID (+) = base.LOCATOR_ID
510: and (
511: mil.PROJECT_ID IS NULL

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

512: )
513: and mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
514: and mlna.INVENTORY_ITEM_ID (+) = base.INVENTORY_ITEM_ID
515: and mlna.LOT_NUMBER (+) = base.LOT_NUMBER
516: 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
517: ,base.INVENTORY_ITEM_ID
518: ,base.REVISION
519: ,base.LOT_NUMBER
520: ,base.LOT_EXPIRATION_DATE

Line 538: p_cursor IN WMS_RULE_PVT.cv_pick_type,

534:
535: END open_curs;
536:
537: PROCEDURE fetch_one_row(
538: p_cursor IN WMS_RULE_PVT.cv_pick_type,
539: x_revision OUT NOCOPY VARCHAR2,
540: x_lot_number OUT NOCOPY VARCHAR2,
541: x_lot_expiration_date OUT NOCOPY DATE,
542: x_subinventory_code OUT NOCOPY VARCHAR2,

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

582:
583:
584: END fetch_one_row;
585:
586: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
587: BEGIN
588: if (p_cursor%ISOPEN) THEN
589: CLOSE p_cursor;
590: END IF;

Line 595: p_cursor IN WMS_RULE_PVT.cv_pick_type,

591: END close_curs;
592:
593: -- LG convergence new procedure for the new manual picking select screen
594: PROCEDURE fetch_available_rows(
595: p_cursor IN WMS_RULE_PVT.cv_pick_type,
596: x_return_status OUT NOCOPY NUMBER) IS
597:
598: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
599: