APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_QC_STATUS_TL

Line 57: GMD_QC_STATUS_TL T ,

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
60: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
61: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 58: GMD_QC_STATUS_TL P

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
60: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
61: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
62: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 74: GMD_QC_STATUS_TL T ,

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
77: AND I.ORGANIZATION_ID = S.OWNER_ORGANIZATION_ID
78: AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID

Line 75: GMD_QC_STATUS_TL P

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
77: AND I.ORGANIZATION_ID = S.OWNER_ORGANIZATION_ID
78: AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
79: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 91: GMD_QC_STATUS_TL T ,

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
94: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
95: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 92: GMD_QC_STATUS_TL P

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
94: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
95: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
96: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 108: GMD_QC_STATUS_TL T ,

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
111: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
112: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 109: GMD_QC_STATUS_TL P

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
111: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
112: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
113: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 124: GMD_QC_STATUS_TL P ,

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
128: AND T.ENTITY_TYPE = 'S'

Line 125: GMD_QC_STATUS_TL T

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
128: AND T.ENTITY_TYPE = 'S'
129: AND T.LANGUAGE = USERENV ( 'LANG' )

Line 138: GMD_QC_STATUS_TL T ,

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
142: AND S.SPEC_STATUS = L.STATUS_CODE

Line 139: GMD_QC_STATUS_TL L

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
142: AND S.SPEC_STATUS = L.STATUS_CODE
143: AND T.ENTITY_TYPE = 'S'