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.

[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on GMD_SPECIFICATIONS_B

Line 3383: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb

3379: )
3380:
3381: )
3382: AND (exists (select gisv.spec_id
3383: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb
3384: where gsb.inventory_item_id = mmt.inventory_item_id
3385: and gsb.spec_status in (400,700)
3386: and gsb.delete_mark = 0
3387: and gisv.spec_id = gsb.spec_id

Line 3396: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb

3392: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3393: ,inv_globals.g_sourcetype_rma
3394: ,inv_globals.g_sourcetype_intreq))
3395: AND ( (exists (select gssv.spec_id
3396: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3397: where gsb.inventory_item_id = mmt.inventory_item_id
3398: and gsb.spec_status in (400,700)
3399: and gsb.delete_mark = 0
3400: and gssv.spec_id = gsb.spec_id

Line 3404: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb

3400: and gssv.spec_id = gsb.spec_id
3401: and gssv.delete_mark = 0
3402: and (gssv.organization_id is null OR gssv.organization_id = mmt.organization_id)))
3403: OR (exists (select gisv.spec_id
3404: from gmd_inventory_spec_vrs gisv, gmd_specifications_b gsb
3405: where gsb.inventory_item_id = mmt.inventory_item_id
3406: and gsb.spec_status in (400,700)
3407: and gsb.delete_mark = 0
3408: and gisv.spec_id = gsb.spec_id