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 403: AND inventory_item_id in (select inventory_item_id from mtl_txn_request_lines where header_id =to_number(p_header_id))

399: NVL(DUAL_UOM_DEVIATION_LOW,0)
400: FROM mtl_system_items_vl /* Bug 5581528 */
401: WHERE organization_id = p_organization_id
402: AND concatenated_segments LIKE nvl(l_concatenated_segments,concatenated_segments)
403: AND inventory_item_id in (select inventory_item_id from mtl_txn_request_lines where header_id =to_number(p_header_id))
404:
405: --Changes for GTIN
406: UNION
407:

Line 3201: FROM mtl_txn_request_lines b , mtl_system_items_vl a /* Bug 5581528 */ --BUG12820609 changed order of MTRL and MSI

3197: NVL(a.SECONDARY_DEFAULT_IND,''),
3198: NVL(a.TRACKING_QUANTITY_IND,'P'),
3199: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3200: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3201: FROM mtl_txn_request_lines b , mtl_system_items_vl a /* Bug 5581528 */ --BUG12820609 changed order of MTRL and MSI
3202: WHERE b.lpn_id = p_lpn_id
3203: AND b.organization_id = p_organization_id
3204: AND b.inspection_status is not null -- 8405606
3205: AND b.organization_id = a.organization_id

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

3256: NVL(a.SECONDARY_DEFAULT_IND,''),
3257: NVL(a.TRACKING_QUANTITY_IND,'P'),
3258: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3259: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3260: FROM mtl_txn_request_lines b, mtl_system_items_vl a, /* Bug 5581528 */
3261: mtl_cross_references mcr
3262: WHERE b.lpn_id = p_lpn_id
3263: AND b.organization_id = p_organization_id
3264: AND b.inspection_status is not null -- 8405606

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

3322: NVL(a.SECONDARY_DEFAULT_IND,''),
3323: NVL(a.TRACKING_QUANTITY_IND,'P'),
3324: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3325: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3326: FROM mtl_txn_request_lines b, mtl_system_items_vl a /* Bug 5581528 */
3327: WHERE b.lpn_id = p_lpn_id
3328: AND b.organization_id = p_organization_id
3329: AND b.inspection_status is not null -- 8405606
3330: AND b.organization_id = a.organization_id

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

3382: NVL(a.SECONDARY_DEFAULT_IND,''),
3383: NVL(a.TRACKING_QUANTITY_IND,'P'),
3384: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3385: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3386: FROM mtl_txn_request_lines b, mtl_system_items_vl a /* Bug 5581528 */
3387: WHERE b.lpn_id = p_lpn_id
3388: AND b.organization_id = p_organization_id
3389: AND b.inspection_status is not null -- 8405606
3390: AND b.organization_id = a.organization_id

Line 3423: FROM mtl_item_revisions a, mtl_txn_request_lines b

3419: OPEN x_revs FOR
3420: SELECT DISTINCT a.revision
3421: , a.effectivity_date
3422: , NVL(a.description, '')
3423: FROM mtl_item_revisions a, mtl_txn_request_lines b
3424: WHERE b.organization_id = p_organization_id
3425: AND b.inventory_item_id = p_inventory_item_id
3426: AND b.lpn_id = p_lpn_id
3427: AND b.inspection_status is not null --8405606