APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_SPECIFICATIONS_B

Line 55: GMD_SPECIFICATIONS_B S ,

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

Line 72: GMD_SPECIFICATIONS_B S ,

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

Line 89: GMD_SPECIFICATIONS_B S ,

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

Line 106: GMD_SPECIFICATIONS_B S ,

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

Line 123: GMD_SPECIFICATIONS_B S ,

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

Line 137: GMD_SPECIFICATIONS_B S ,

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