APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SPECIFICATIONS_B

Line 78: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b

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

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

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

Line 307: FROM gmd_specifications_b a,gmd_customer_spec_vrs b

303: CURSOR cr_match_spec IS
304: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
305: 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,
306: b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id
307: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
308: WHERE
309: a.inventory_item_id = p_customer_spec_rec.inventory_item_id
310: AND ((p_customer_spec_rec.revision = a.revision) OR ( p_customer_spec_rec.revision IS NULL AND a.revision IS NULL)
311: OR (p_customer_spec_rec.revision IS NOT NULL AND a.revision IS NULL ))

Line 582: FROM gmd_specifications_b a,

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

Line 1016: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

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

Line 1475: FROM gmd_specifications_b a,

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

Line 1587: FROM gmd_specifications_b a,

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