APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_SPECIFICATIONS_B

Line 77: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b

73: a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
74: p_inventory_spec_rec.grade,1,2),
75: b.location,b.whse_code,b.sublot_no,b.lot_no,
76: b.orgn_code
77: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b
78: WHERE
79: a.item_id = p_inventory_spec_rec.item_id
80: AND a.delete_mark = 0
81: AND ((l_check_for_given_grade = 'Y' and p_inventory_spec_rec.grade = a.grade ) OR (l_check_for_null_grade = 'Y' AND a.grade IS NULL )

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

100: SELECT a.spec_id,b.spec_vr_id,a.grade,decode(a.grade,
101: p_inventory_spec_rec.grade,1,2),
102: b.location,b.whse_code,b.sublot_no,b.lot_no,
103: b.orgn_code
104: FROM gmd_specifications_b a,gmd_inventory_spec_vrs b , gmd_spec_tests_b c
105: WHERE
106: a.item_id = p_inventory_spec_rec.item_id
107: AND a.delete_mark = 0
108: AND ((l_check_for_given_grade = 'Y' and p_inventory_spec_rec.grade = a.grade )

Line 319: FROM gmd_specifications_b a,gmd_customer_spec_vrs b

315:
316: CURSOR cr_match_spec IS
317: SELECT /*+ INDEX (b gmd_customer_spec_vrs_n1 ) */
318: a.spec_id,b.spec_vr_id,a.grade grade,DECODE(a.grade,p_customer_spec_rec.grade,1,2) grade_order_by,b.order_line_id,b.order_line,b.order_id,b.ship_to_site_id,b.org_id,DECODE(b.orgn_code,l_orgn_code,1,NULL,2,3) orgn_code_order_by,b.orgn_code
319: FROM gmd_specifications_b a,gmd_customer_spec_vrs b
320: WHERE
321: a.item_id = p_customer_spec_rec.item_id
322: AND a.delete_mark = 0
323: AND ((l_check_for_given_grade = 'Y' and p_customer_spec_rec.grade = a.grade )

Line 622: FROM gmd_specifications_b a,gmd_wip_spec_vrs b

618: b.charge,b.step_no,
619: b.routing_vers,b.routing_no,b.formulaline_id,
620: b.formula_vers,b.formula_no,b.recipe_version,
621: b.recipe_no,b.batch_id,b.oprn_vers,b.oprn_no,b.orgn_code
622: FROM gmd_specifications_b a,gmd_wip_spec_vrs b
623: WHERE
624: a.item_id = p_wip_spec_rec.item_id
625: AND a.delete_mark = 0
626: AND ((l_check_for_given_grade = 'Y' and p_wip_spec_rec.grade = a.grade ) OR (l_check_for_null_grade = 'Y' AND a.grade IS NULL )

Line 1028: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b

1024: SELECT /*+ INDEX ( b gmd_supplier_spec_vrs_n1) */
1025: a.spec_id,b.spec_vr_id,a.grade,
1026: decode(a.grade,p_supplier_spec_rec.grade,1,2),b.po_line_id,
1027: b.po_header_id,b.supplier_site_id,b.supplier_id,b.orgn_code
1028: FROM gmd_specifications_b a,gmd_supplier_spec_vrs b
1029: WHERE
1030: a.item_id = p_supplier_spec_rec.item_id
1031: AND a.delete_mark = 0
1032: AND ((l_check_for_given_grade = 'Y' and p_supplier_spec_rec.grade = a.grade )