APPS.GMF_GMFLCHST_XMLP_PKG dependencies on MTL_PARAMETERS

Line 137: MTL_PARAMETERS MP

133: MP.ORGANIZATION_CODE || ' ' || R.RECEIPT_NUM
134: FROM
135: RCV_SHIPMENT_HEADERS R,
136: MTL_MATERIAL_TRANSACTIONS P,
137: MTL_PARAMETERS MP
138: WHERE R.SHIPMENT_HEADER_ID = P.TRANSACTION_SOURCE_ID
139: AND R.ORGANIZATION_ID = P.ORGANIZATION_ID
140: AND P.TRANSACTION_SOURCE_ID = DOC_ID
141: AND P.TRX_SOURCE_LINE_ID = LINE_ID

Line 158: MTL_PARAMETERS MP,

154: SELECT
155: MP.ORGANIZATION_CODE || ' ' || MCC.COUNT_LIST_SEQUENCE
156: FROM
157: MTL_MATERIAL_TRANSACTIONS MTT,
158: MTL_PARAMETERS MP,
159: MTL_CYCLE_COUNT_ENTRIES MCC
160: WHERE MTT.CYCLE_COUNT_ID = DOC_ID
161: AND MP.ORGANIZATION_ID = MTT.ORGANIZATION_ID
162: AND MCC.CYCLE_COUNT_ENTRY_ID = MTT.CYCLE_COUNT_ID;

Line 168: MTL_PARAMETERS MP

164: SELECT
165: MP.ORGANIZATION_CODE
166: FROM
167: MTL_MATERIAL_TRANSACTIONS MMT,
168: MTL_PARAMETERS MP
169: WHERE MMT.TRANSFER_TRANSACTION_ID = DOC_ID
170: AND MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID;
171: CURSOR C_SO_DOC(P_DOC_ID IN NUMBER,P_LEGAL_ENTITY_ID IN NUMBER,P_LINE_ID IN NUMBER) IS
172: SELECT

Line 180: MTL_PARAMETERS MP,

176: WSH_NEW_DELIVERIES D,
177: MTL_MATERIAL_TRANSACTIONS T,
178: WSH_DELIVERY_DETAILS WD,
179: WSH_DELIVERY_ASSIGNMENTS WA,
180: MTL_PARAMETERS MP,
181: MTL_TXN_SOURCE_TYPES MTST,
182: ORG_ORGANIZATION_DEFINITIONS OOD
183: WHERE D.DELIVERY_ID = WA.DELIVERY_ID
184: AND WA.DELIVERY_DETAIL_ID = WD.DELIVERY_DETAIL_ID

Line 197: MTL_PARAMETERS MP,

193: SELECT
194: DISTINCT
195: '(Bill-Only) ' || MP.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
196: FROM
197: MTL_PARAMETERS MP,
198: MTL_MATERIAL_TRANSACTIONS T,
199: OE_ORDER_HEADERS_ALL OH,
200: OE_ORDER_LINES_ALL OL,
201: MTL_TXN_SOURCE_TYPES MTST,