DBA Data[Home] [Help]

APPS.GMD_AUTO_SAMPLE_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 56: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 73: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 90: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 107: MTL_SYSTEM_ITEMS_KFV I ,

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