eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_SPECIFICATIONS_B

Line 576: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr

572: RETURN BOOLEAN IS
573:
574: CURSOR c_mon_vr IS
575: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
576: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr
577: WHERE s.spec_id = vr.spec_id
578: AND ((s.grade_code is NULL AND p_spec.grade_code is NULL) OR
579: (s.grade_code = p_spec.grade_code)
580: )

Line 1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr

1218: RETURN BOOLEAN IS
1219:
1220: CURSOR c_inv_vr IS
1221: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
1222: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr
1223: WHERE s.spec_id = vr.spec_id
1224: AND s.owner_organization_id = p_spec.owner_organization_id
1225: AND s.inventory_item_id = p_spec.inventory_item_id
1226: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 2539: FROM gmd_specifications_b s,

2535:
2536: -- added material detail to cursor
2537: CURSOR c_wip_vr IS
2538: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
2539: FROM gmd_specifications_b s,
2540: gmd_wip_spec_vrs vr
2541: WHERE s.spec_id = vr.spec_id
2542: AND s.owner_organization_id = p_spec.owner_organization_id
2543: AND s.inventory_item_id = p_spec.inventory_item_id

Line 3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr

3209: RETURN BOOLEAN IS
3210:
3211: CURSOR c_cust_vr IS
3212: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3213: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr
3214: WHERE s.spec_id = vr.spec_id
3215: AND s.owner_organization_id = p_spec.owner_organization_id
3216: AND s.inventory_item_id = p_spec.inventory_item_id
3217: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3860: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr

3856: RETURN BOOLEAN IS
3857:
3858: CURSOR c_supp_vr IS
3859: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3860: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr
3861: WHERE s.spec_id = vr.spec_id
3862: AND s.owner_organization_id = p_spec.owner_organization_id
3863: AND s.inventory_item_id = p_spec.inventory_item_id
3864: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733