DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_QC_STATUS

Line 1452: gmd_qc_status qs1,

1448: b.subinventory,
1449: b.locator_id
1450: FROM gmd_specifications_b a,
1451: gmd_monitoring_spec_vrs b,
1452: gmd_qc_status qs1,
1453: gmd_qc_status qs2
1454: WHERE (a.spec_status = qs1.status_code AND
1455: qs1.entity_type = 'S' AND
1456: qs1.status_type in (400, 700, 900)

Line 1453: gmd_qc_status qs2

1449: b.locator_id
1450: FROM gmd_specifications_b a,
1451: gmd_monitoring_spec_vrs b,
1452: gmd_qc_status qs1,
1453: gmd_qc_status qs2
1454: WHERE (a.spec_status = qs1.status_code AND
1455: qs1.entity_type = 'S' AND
1456: qs1.status_type in (400, 700, 900)
1457: )

Line 1564: gmd_qc_status qs1,

1560: b.resources,
1561: b.resource_instance_id
1562: FROM gmd_specifications_b a,
1563: gmd_monitoring_spec_vrs b,
1564: gmd_qc_status qs1,
1565: gmd_qc_status qs2
1566: WHERE (a.spec_status = qs1.status_code AND
1567: qs1.entity_type = 'S' AND
1568: qs1.status_type in (400, 700, 900)

Line 1565: gmd_qc_status qs2

1561: b.resource_instance_id
1562: FROM gmd_specifications_b a,
1563: gmd_monitoring_spec_vrs b,
1564: gmd_qc_status qs1,
1565: gmd_qc_status qs2
1566: WHERE (a.spec_status = qs1.status_code AND
1567: qs1.entity_type = 'S' AND
1568: qs1.status_type in (400, 700, 900)
1569: )