APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SPECIFICATIONS_B

Line 75: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b

71: a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
72: p_inventory_spec_rec.grade_code,1,2),
73: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
74: b.organization_id
75: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b
76: WHERE
77: a.inventory_item_id = p_inventory_spec_rec.inventory_item_id
78: AND ((p_inventory_spec_rec.revision = a.revision) OR ( p_inventory_spec_rec.revision IS NULL AND a.revision IS NULL)
79: OR (p_inventory_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 106: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c

102: SELECT a.spec_id,b.spec_vr_id,a.grade_code,revision,decode(a.grade_code,
103: p_inventory_spec_rec.grade_code,1,2),
104: b.locator_id,b.subinventory,b.parent_lot_number,b.lot_number,
105: b.organization_id
106: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
107: WHERE
108: a.inventory_item_id = p_inventory_spec_rec.inventory_item_id
109: AND ((p_inventory_spec_rec.revision = a.revision) OR ( p_inventory_spec_rec.revision IS NULL AND a.revision IS NULL)
110: OR (p_inventory_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 304: FROM gmd_specifications_b a,gmd_customer_spec_vrs b

300: CURSOR cr_match_spec IS
301: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
302: a.spec_id,b.spec_vr_id,a.revision,a.grade_code ,DECODE(a.grade_code,p_customer_spec_rec.grade_code,1,2) grade_order_by,
303: b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id
304: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
305: WHERE
306: a.inventory_item_id = p_customer_spec_rec.inventory_item_id
307: AND ((p_customer_spec_rec.revision = a.revision) OR ( p_customer_spec_rec.revision IS NULL AND a.revision IS NULL)
308: OR (p_customer_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 579: FROM gmd_specifications_b a,

575: b.batch_id,
576: b.oprn_vers,
577: b.oprn_no,
578: b.organization_id
579: FROM gmd_specifications_b a,
580: gmd_wip_spec_vrs b
581: WHERE
582: a.inventory_item_id = p_wip_spec_rec.inventory_item_id
583: AND ((p_wip_spec_rec.revision = a.revision)

Line 1013: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

1009: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1010: a.spec_id,b.spec_vr_id,a.revision,a.grade_code,
1011: decode(a.grade_code,p_supplier_spec_rec.grade_code,1,2),b.po_line_id,
1012: b.po_header_id,b.supplier_site_id,b.supplier_id
1013: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b
1014: WHERE
1015: a.inventory_item_id = p_supplier_spec_rec.inventory_item_id
1016: AND ((p_supplier_spec_rec.revision = a.revision) OR ( p_supplier_spec_rec.revision IS NULL AND a.revision IS NULL)
1017: OR (p_supplier_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 1450: FROM gmd_specifications_b a,

1446: SELECT a.spec_id, b.spec_vr_id,
1447: b.locator_organization_id,
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

Line 1562: FROM gmd_specifications_b a,

1558: SELECT a.spec_id, b.spec_vr_id,
1559: b.resource_organization_id,
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