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_LPN_LOVS dependencies on INV_PROJECT

Line 227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||

223: ' wlpn.gross_weight_uom_code, ' ||
224: ' NVL(wlpn.gross_weight, 0), ' ||
225: ' wlpn.content_volume_uom_code, ' ||
226: ' NVL(wlpn.content_volume, 0), ' ||
227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||
228: ' INV_PROJECT.GET_PROJECT_ID, ' ||
229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||
230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||

Line 228: ' INV_PROJECT.GET_PROJECT_ID, ' ||

224: ' NVL(wlpn.gross_weight, 0), ' ||
225: ' wlpn.content_volume_uom_code, ' ||
226: ' NVL(wlpn.content_volume, 0), ' ||
227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||
228: ' INV_PROJECT.GET_PROJECT_ID, ' ||
229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||
230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||
232: ' wlpn.lpn_context ' ||

Line 229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||

225: ' wlpn.content_volume_uom_code, ' ||
226: ' NVL(wlpn.content_volume, 0), ' ||
227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||
228: ' INV_PROJECT.GET_PROJECT_ID, ' ||
229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||
230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||
232: ' wlpn.lpn_context ' ||
233: 'FROM wms_license_plate_numbers wlpn, ' ||

Line 230: ' INV_PROJECT.GET_TASK_ID, ' ||

226: ' NVL(wlpn.content_volume, 0), ' ||
227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||
228: ' INV_PROJECT.GET_PROJECT_ID, ' ||
229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||
230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||
232: ' wlpn.lpn_context ' ||
233: 'FROM wms_license_plate_numbers wlpn, ' ||
234: ' mtl_item_locations milk, ' ||

Line 231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||

227: ' INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id,milk.organization_id), ' ||
228: ' INV_PROJECT.GET_PROJECT_ID, ' ||
229: ' INV_PROJECT.GET_PROJECT_NUMBER, ' ||
230: ' INV_PROJECT.GET_TASK_ID, ' ||
231: ' INV_PROJECT.GET_TASK_NUMBER, ' ||
232: ' wlpn.lpn_context ' ||
233: 'FROM wms_license_plate_numbers wlpn, ' ||
234: ' mtl_item_locations milk, ' ||
235: ' wms_lpn_contents wlc ' ||

Line 3111: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),

3107: NVL(wlpn.gross_weight, 0),
3108: wlpn.content_volume_uom_code,
3109: NVL(wlpn.content_volume, 0),
3110: --milk.concatenated_segments locator_code,
3111: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3112: wlc.cost_group_id,
3113: INV_PROJECT.GET_PROJECT_ID,
3114: INV_PROJECT.GET_PROJECT_NUMBER,
3115: INV_PROJECT.GET_TASK_ID,

Line 3113: INV_PROJECT.GET_PROJECT_ID,

3109: NVL(wlpn.content_volume, 0),
3110: --milk.concatenated_segments locator_code,
3111: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3112: wlc.cost_group_id,
3113: INV_PROJECT.GET_PROJECT_ID,
3114: INV_PROJECT.GET_PROJECT_NUMBER,
3115: INV_PROJECT.GET_TASK_ID,
3116: INV_PROJECT.GET_TASK_NUMBER
3117: FROM wms_license_plate_numbers wlpn,

Line 3114: INV_PROJECT.GET_PROJECT_NUMBER,

3110: --milk.concatenated_segments locator_code,
3111: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3112: wlc.cost_group_id,
3113: INV_PROJECT.GET_PROJECT_ID,
3114: INV_PROJECT.GET_PROJECT_NUMBER,
3115: INV_PROJECT.GET_TASK_ID,
3116: INV_PROJECT.GET_TASK_NUMBER
3117: FROM wms_license_plate_numbers wlpn,
3118: wms_lpn_contents wlc,

Line 3115: INV_PROJECT.GET_TASK_ID,

3111: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3112: wlc.cost_group_id,
3113: INV_PROJECT.GET_PROJECT_ID,
3114: INV_PROJECT.GET_PROJECT_NUMBER,
3115: INV_PROJECT.GET_TASK_ID,
3116: INV_PROJECT.GET_TASK_NUMBER
3117: FROM wms_license_plate_numbers wlpn,
3118: wms_lpn_contents wlc,
3119: mtl_item_locations mil

Line 3116: INV_PROJECT.GET_TASK_NUMBER

3112: wlc.cost_group_id,
3113: INV_PROJECT.GET_PROJECT_ID,
3114: INV_PROJECT.GET_PROJECT_NUMBER,
3115: INV_PROJECT.GET_TASK_ID,
3116: INV_PROJECT.GET_TASK_NUMBER
3117: FROM wms_license_plate_numbers wlpn,
3118: wms_lpn_contents wlc,
3119: mtl_item_locations mil
3120: WHERE (mil.inventory_location_id = wlpn.locator_id

Line 3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),

3164: NVL(wlpn.gross_weight, 0),
3165: wlpn.content_volume_uom_code,
3166: NVL(wlpn.content_volume, 0),
3167: --milk.concatenated_segments locator_code
3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3169: INV_PROJECT.GET_PROJECT_ID,
3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER

Line 3169: INV_PROJECT.GET_PROJECT_ID,

3165: wlpn.content_volume_uom_code,
3166: NVL(wlpn.content_volume, 0),
3167: --milk.concatenated_segments locator_code
3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3169: INV_PROJECT.GET_PROJECT_ID,
3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER
3173: FROM wms_license_plate_numbers wlpn,

Line 3170: INV_PROJECT.GET_PROJECT_NUMBER,

3166: NVL(wlpn.content_volume, 0),
3167: --milk.concatenated_segments locator_code
3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3169: INV_PROJECT.GET_PROJECT_ID,
3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER
3173: FROM wms_license_plate_numbers wlpn,
3174: mtl_item_locations mil

Line 3171: INV_PROJECT.GET_TASK_ID,

3167: --milk.concatenated_segments locator_code
3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3169: INV_PROJECT.GET_PROJECT_ID,
3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER
3173: FROM wms_license_plate_numbers wlpn,
3174: mtl_item_locations mil
3175: WHERE mil.inventory_location_id(+) = wlpn.locator_id --OUTER JOIN is added for bug 3876495

Line 3172: INV_PROJECT.GET_TASK_NUMBER

3168: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),
3169: INV_PROJECT.GET_PROJECT_ID,
3170: INV_PROJECT.GET_PROJECT_NUMBER,
3171: INV_PROJECT.GET_TASK_ID,
3172: INV_PROJECT.GET_TASK_NUMBER
3173: FROM wms_license_plate_numbers wlpn,
3174: mtl_item_locations mil
3175: WHERE mil.inventory_location_id(+) = wlpn.locator_id --OUTER JOIN is added for bug 3876495
3176: AND wlpn.license_plate_number LIKE (p_lpn)

Line 3639: * Use the function INV_PROJECT.get_locsegs() to retrieve the

3635: END GET_CYC_LPN_LOV;
3636:
3637: /* PJM-WMS Integration:Return only the LPNs residing in physical locators.
3638: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3639: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3640: * concatenated segments.
3641: */
3642: PROCEDURE GET_CGUPDATE_LPN
3643: (x_lpn_lov OUT NOCOPY t_genref,

Line 3656: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id,p_org_id)

3652: wlpn.lpn_id,
3653: wlpn.subinventory_code,
3654: wlpn.locator_id,
3655: -- PJM-WMS Integration
3656: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id,p_org_id)
3657: FROM mtl_item_locations mil,-- -PJM-WMS Integration
3658: wms_license_plate_numbers wlpn
3659: WHERE mil.inventory_location_id = wlpn.locator_id
3660: AND mil.organization_id = wlpn.organization_id

Line 3852: by making a call to the procedure INV_PROJECT.GET_LOCSEGS

3848: /**********************************************************************************
3849: WMS - PJM Integration Enhancements
3850: Differences from CHECK_LPN_LOV
3851: 1. Returns the locator concatenated segments without SEGMENT19 and SEGMENT20.
3852: by making a call to the procedure INV_PROJECT.GET_LOCSEGS
3853: 2. Returns the Project ID, Project Number, Task ID and Task Number associated
3854: with the locator by making a call to the package INV_PROJECT.
3855: **********************************************************************************/
3856: PROCEDURE CHECK_PJM_LPN_LOV

Line 3854: with the locator by making a call to the package INV_PROJECT.

3850: Differences from CHECK_LPN_LOV
3851: 1. Returns the locator concatenated segments without SEGMENT19 and SEGMENT20.
3852: by making a call to the procedure INV_PROJECT.GET_LOCSEGS
3853: 2. Returns the Project ID, Project Number, Task ID and Task Number associated
3854: with the locator by making a call to the package INV_PROJECT.
3855: **********************************************************************************/
3856: PROCEDURE CHECK_PJM_LPN_LOV
3857: ( p_lpn IN VARCHAR2,
3858: p_organization_id IN NUMBER,

Line 3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),

3914: cost_group_id,
3915: 'FALSE',
3916: LOCATOR_ID,
3917: LPN_CONTEXT,
3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),
3919: INV_PROJECT.GET_PROJECT_ID,
3920: INV_PROJECT.GET_PROJECT_NUMBER,
3921: INV_PROJECT.GET_TASK_ID,
3922: INV_PROJECT.GET_TASK_NUMBER

Line 3919: INV_PROJECT.GET_PROJECT_ID,

3915: 'FALSE',
3916: LOCATOR_ID,
3917: LPN_CONTEXT,
3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),
3919: INV_PROJECT.GET_PROJECT_ID,
3920: INV_PROJECT.GET_PROJECT_NUMBER,
3921: INV_PROJECT.GET_TASK_ID,
3922: INV_PROJECT.GET_TASK_NUMBER
3923: INTO x_lpn_id,

Line 3920: INV_PROJECT.GET_PROJECT_NUMBER,

3916: LOCATOR_ID,
3917: LPN_CONTEXT,
3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),
3919: INV_PROJECT.GET_PROJECT_ID,
3920: INV_PROJECT.GET_PROJECT_NUMBER,
3921: INV_PROJECT.GET_TASK_ID,
3922: INV_PROJECT.GET_TASK_NUMBER
3923: INTO x_lpn_id,
3924: x_inventory_item_id,

Line 3921: INV_PROJECT.GET_TASK_ID,

3917: LPN_CONTEXT,
3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),
3919: INV_PROJECT.GET_PROJECT_ID,
3920: INV_PROJECT.GET_PROJECT_NUMBER,
3921: INV_PROJECT.GET_TASK_ID,
3922: INV_PROJECT.GET_TASK_NUMBER
3923: INTO x_lpn_id,
3924: x_inventory_item_id,
3925: x_organization_id,

Line 3922: INV_PROJECT.GET_TASK_NUMBER

3918: INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORGANIZATION_ID),
3919: INV_PROJECT.GET_PROJECT_ID,
3920: INV_PROJECT.GET_PROJECT_NUMBER,
3921: INV_PROJECT.GET_TASK_ID,
3922: INV_PROJECT.GET_TASK_NUMBER
3923: INTO x_lpn_id,
3924: x_inventory_item_id,
3925: x_organization_id,
3926: x_lot_number,