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 3112: INV_PROJECT.GET_LOCSEGS(mil.inventory_location_id, p_organization_id),

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

Line 3114: INV_PROJECT.GET_PROJECT_ID,

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

Line 3115: INV_PROJECT.GET_PROJECT_NUMBER,

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

Line 3116: INV_PROJECT.GET_TASK_ID,

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

Line 3117: INV_PROJECT.GET_TASK_NUMBER

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

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

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

Line 3170: INV_PROJECT.GET_PROJECT_ID,

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

Line 3171: INV_PROJECT.GET_PROJECT_NUMBER,

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

Line 3172: INV_PROJECT.GET_TASK_ID,

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

Line 3173: INV_PROJECT.GET_TASK_NUMBER

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

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

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

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

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

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

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

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

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

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

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

Line 3920: INV_PROJECT.GET_PROJECT_ID,

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

Line 3921: INV_PROJECT.GET_PROJECT_NUMBER,

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

Line 3922: INV_PROJECT.GET_TASK_ID,

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

Line 3923: INV_PROJECT.GET_TASK_NUMBER

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