DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on GMD_INVENTORY_SPEC_VRS

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 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