DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

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