APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_SPECIFICATIONS_B

Line 58: GMD_SPECIFICATIONS_B S ,

54: from gmd_all_spec_vrs
55: where spec_vr_id = x_spec_vr_id ; */
56: SELECT nvl (v.SAMPLE_INV_TRANS_IND, 'N') SAMPLE_INV_TRANS_IND
57: FROM GMD_INVENTORY_SPEC_VRS V ,
58: GMD_SPECIFICATIONS_B S ,
59: MTL_SYSTEM_ITEMS_KFV I ,
60: GMD_QC_STATUS_TL T ,
61: GMD_QC_STATUS_TL P
62: WHERE V.SPEC_ID = S.SPEC_ID

Line 75: GMD_SPECIFICATIONS_B S ,

71: and v.spec_vr_id = x_spec_vr_id
72: UNION
73: SELECT nvl (v.SAMPLE_INV_TRANS_IND, 'N') SAMPLE_INV_TRANS_IND
74: FROM GMD_WIP_SPEC_VRS V ,
75: GMD_SPECIFICATIONS_B S ,
76: MTL_SYSTEM_ITEMS_KFV I ,
77: GMD_QC_STATUS_TL T ,
78: GMD_QC_STATUS_TL P
79: WHERE V.SPEC_ID = S.SPEC_ID

Line 92: GMD_SPECIFICATIONS_B S ,

88: and v.spec_vr_id = x_spec_vr_id
89: UNION
90: SELECT nvl (v.SAMPLE_INV_TRANS_IND, 'N') SAMPLE_INV_TRANS_IND
91: FROM GMD_CUSTOMER_SPEC_VRS V ,
92: GMD_SPECIFICATIONS_B S ,
93: MTL_SYSTEM_ITEMS_KFV I ,
94: GMD_QC_STATUS_TL T ,
95: GMD_QC_STATUS_TL P
96: WHERE V.SPEC_ID = S.SPEC_ID

Line 109: GMD_SPECIFICATIONS_B S ,

105: and v.spec_vr_id = x_spec_vr_id
106: UNION
107: SELECT nvl (v.SAMPLE_INV_TRANS_IND, 'N') SAMPLE_INV_TRANS_IND
108: FROM GMD_SUPPLIER_SPEC_VRS V ,
109: GMD_SPECIFICATIONS_B S ,
110: MTL_SYSTEM_ITEMS_KFV I ,
111: GMD_QC_STATUS_TL T ,
112: GMD_QC_STATUS_TL P
113: WHERE V.SPEC_ID = S.SPEC_ID

Line 126: GMD_SPECIFICATIONS_B S ,

122: and v.spec_vr_id = x_spec_vr_id
123: UNION
124: SELECT 'N' SAMPLE_INV_TRANS_IND
125: FROM GMD_MONITORING_SPEC_VRS V ,
126: GMD_SPECIFICATIONS_B S ,
127: GMD_QC_STATUS_TL P ,
128: GMD_QC_STATUS_TL T
129: WHERE V.SPEC_ID = S.SPEC_ID
130: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 140: GMD_SPECIFICATIONS_B S ,

136: and v.spec_vr_id = x_spec_vr_id
137: UNION
138: SELECT 'N' SAMPLE_INV_TRANS_IND
139: FROM GMD_STABILITY_SPEC_VRS V ,
140: GMD_SPECIFICATIONS_B S ,
141: GMD_QC_STATUS_TL T ,
142: GMD_QC_STATUS_TL L
143: WHERE V.SPEC_ID = S.SPEC_ID
144: AND V.SPEC_VR_STATUS = T.STATUS_CODE