DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_QC_STATUS

Line 1477: gmd_qc_status qs1,

1473: b.subinventory,
1474: b.locator_id
1475: FROM gmd_specifications_b a,
1476: gmd_monitoring_spec_vrs b,
1477: gmd_qc_status qs1,
1478: gmd_qc_status qs2
1479: WHERE (a.spec_status = qs1.status_code AND
1480: qs1.entity_type = 'S' AND
1481: qs1.status_type in (400, 700, 900)

Line 1478: gmd_qc_status qs2

1474: b.locator_id
1475: FROM gmd_specifications_b a,
1476: gmd_monitoring_spec_vrs b,
1477: gmd_qc_status qs1,
1478: gmd_qc_status qs2
1479: WHERE (a.spec_status = qs1.status_code AND
1480: qs1.entity_type = 'S' AND
1481: qs1.status_type in (400, 700, 900)
1482: )

Line 1589: gmd_qc_status qs1,

1585: b.resources,
1586: b.resource_instance_id
1587: FROM gmd_specifications_b a,
1588: gmd_monitoring_spec_vrs b,
1589: gmd_qc_status qs1,
1590: gmd_qc_status qs2
1591: WHERE (a.spec_status = qs1.status_code AND
1592: qs1.entity_type = 'S' AND
1593: qs1.status_type in (400, 700, 900)

Line 1590: gmd_qc_status qs2

1586: b.resource_instance_id
1587: FROM gmd_specifications_b a,
1588: gmd_monitoring_spec_vrs b,
1589: gmd_qc_status qs1,
1590: gmd_qc_status qs2
1591: WHERE (a.spec_status = qs1.status_code AND
1592: qs1.entity_type = 'S' AND
1593: qs1.status_type in (400, 700, 900)
1594: )