DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

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