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.INV_UI_ITEM_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 363: AND inventory_item_id in (select inventory_item_id from mtl_txn_request_lines where header_id =to_number(p_header_id))

359: NVL(DUAL_UOM_DEVIATION_LOW,0)
360: FROM mtl_system_items_vl /* Bug 5581528 */
361: WHERE organization_id = p_organization_id
362: AND concatenated_segments LIKE nvl(p_concatenated_segments,concatenated_segments)
363: AND inventory_item_id in (select inventory_item_id from mtl_txn_request_lines where header_id =to_number(p_header_id))
364:
365: --Changes for GTIN
366: UNION
367:

Line 3041: FROM mtl_system_items_vl a, mtl_txn_request_lines b /* Bug 5581528 */

3037: NVL(a.SECONDARY_DEFAULT_IND,''),
3038: NVL(a.TRACKING_QUANTITY_IND,'P'),
3039: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3040: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3041: FROM mtl_system_items_vl a, mtl_txn_request_lines b /* Bug 5581528 */
3042: WHERE b.lpn_id = p_lpn_id
3043: AND b.organization_id = p_organization_id
3044: AND b.inspection_status = 1 /* Yet to be inspected */
3045: AND b.organization_id = a.organization_id

Line 3099: mtl_txn_request_lines b,

3095: NVL(a.TRACKING_QUANTITY_IND,'P'),
3096: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3097: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3098: FROM mtl_system_items_vl a, /* Bug 5581528 */
3099: mtl_txn_request_lines b,
3100: mtl_cross_references mcr
3101: WHERE b.lpn_id = p_lpn_id
3102: AND b.organization_id = p_organization_id
3103: AND b.inspection_status = 1 /* Yet to be inspected */

Line 3162: FROM mtl_system_items_vl a, mtl_txn_request_lines b /* Bug 5581528 */

3158: NVL(a.SECONDARY_DEFAULT_IND,''),
3159: NVL(a.TRACKING_QUANTITY_IND,'P'),
3160: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3161: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3162: FROM mtl_system_items_vl a, mtl_txn_request_lines b /* Bug 5581528 */
3163: WHERE b.lpn_id = p_lpn_id
3164: AND b.organization_id = p_organization_id
3165: AND b.inspection_status = 1 /* Yet to be inspected */
3166: AND b.organization_id = a.organization_id

Line 3197: FROM mtl_item_revisions a, mtl_txn_request_lines b

3193: OPEN x_revs FOR
3194: SELECT DISTINCT a.revision
3195: , a.effectivity_date
3196: , NVL(a.description, '')
3197: FROM mtl_item_revisions a, mtl_txn_request_lines b
3198: WHERE b.organization_id = p_organization_id
3199: AND b.inventory_item_id = p_inventory_item_id
3200: AND b.lpn_id = p_lpn_id
3201: AND b.inspection_status = 1 /* yet to be inspected */