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.

[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on GMD_SPECIFICATIONS_B

Line 565: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr

561: RETURN BOOLEAN IS
562:
563: CURSOR c_mon_vr IS
564: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
565: FROM gmd_specifications_b s, gmd_monitoring_spec_vrs vr
566: WHERE s.spec_id = vr.spec_id
567: AND ((s.grade_code is NULL AND p_spec.grade_code is NULL) OR
568: (s.grade_code = p_spec.grade_code)
569: )

Line 1197: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr

1193: RETURN BOOLEAN IS
1194:
1195: CURSOR c_inv_vr IS
1196: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
1197: FROM gmd_specifications_b s, gmd_inventory_spec_vrs vr
1198: WHERE s.spec_id = vr.spec_id
1199: AND s.owner_organization_id = p_spec.owner_organization_id
1200: AND s.inventory_item_id = p_spec.inventory_item_id
1201: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 2390: FROM gmd_specifications_b s,

2386:
2387: -- added material detail to cursor
2388: CURSOR c_wip_vr IS
2389: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
2390: FROM gmd_specifications_b s,
2391: gmd_wip_spec_vrs vr
2392: WHERE s.spec_id = vr.spec_id
2393: AND s.owner_organization_id = p_spec.owner_organization_id
2394: AND s.inventory_item_id = p_spec.inventory_item_id

Line 3063: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr

3059: RETURN BOOLEAN IS
3060:
3061: CURSOR c_cust_vr IS
3062: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3063: FROM gmd_specifications_b s, gmd_customer_spec_vrs vr
3064: WHERE s.spec_id = vr.spec_id
3065: AND s.owner_organization_id = p_spec.owner_organization_id
3066: AND s.inventory_item_id = p_spec.inventory_item_id
3067: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733

Line 3697: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr

3693: RETURN BOOLEAN IS
3694:
3695: CURSOR c_supp_vr IS
3696: SELECT vr.spec_vr_id, s.spec_name, s.spec_vers
3697: FROM gmd_specifications_b s, gmd_supplier_spec_vrs vr
3698: WHERE s.spec_id = vr.spec_id
3699: AND s.owner_organization_id = p_spec.owner_organization_id
3700: AND s.inventory_item_id = p_spec.inventory_item_id
3701: AND ( (s.revision is null and p_spec.revision is NULL ) OR -- handle item revision 5117733