eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_QC_STATUS_TL

Line 60: GMD_QC_STATUS_TL T ,

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

Line 61: GMD_QC_STATUS_TL P

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
63: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
64: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
65: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 77: GMD_QC_STATUS_TL T ,

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

Line 78: GMD_QC_STATUS_TL P

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
80: AND I.ORGANIZATION_ID = S.OWNER_ORGANIZATION_ID
81: AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
82: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 94: GMD_QC_STATUS_TL T ,

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

Line 95: GMD_QC_STATUS_TL P

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
97: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
98: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
99: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 111: GMD_QC_STATUS_TL T ,

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

Line 112: GMD_QC_STATUS_TL P

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
114: AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
115: AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
116: AND V.SPEC_VR_STATUS = T.STATUS_CODE

Line 127: GMD_QC_STATUS_TL P ,

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

Line 128: GMD_QC_STATUS_TL T

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

Line 141: GMD_QC_STATUS_TL T ,

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

Line 142: GMD_QC_STATUS_TL L

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