APPS.GMD_AUTO_SAMPLE_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 59: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 76: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 93: MTL_SYSTEM_ITEMS_KFV I ,

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

Line 110: MTL_SYSTEM_ITEMS_KFV I ,

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