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_LPN_TRX_PUB dependencies on GMD_SPECIFICATIONS_B

Line 3659: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb

3655: )
3656:
3657: )
3658: AND (exists (select gisv.spec_id
3659: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb
3660: where gsb.inventory_item_id = mmt.inventory_item_id
3661: and gsb.spec_status in (400,700)
3662: and gsb.delete_mark = 0
3663: and gisv.spec_id = gsb.spec_id

Line 3672: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb

3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3669: ,inv_globals.g_sourcetype_rma
3670: ,inv_globals.g_sourcetype_intreq))
3671: AND ( (exists (select gssv.spec_id
3672: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3673: where gsb.inventory_item_id = mmt.inventory_item_id
3674: and gsb.spec_status in (400,700)
3675: and gsb.delete_mark = 0
3676: and gssv.spec_id = gsb.spec_id

Line 3680: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb

3676: and gssv.spec_id = gsb.spec_id
3677: and gssv.delete_mark = 0
3678: and (gssv.organization_id is null OR gssv.organization_id = mmt.organization_id)))
3679: OR (exists (select gisv.spec_id
3680: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb
3681: where gsb.inventory_item_id = mmt.inventory_item_id
3682: and gsb.spec_status in (400,700)
3683: and gsb.delete_mark = 0
3684: and gisv.spec_id = gsb.spec_id