APPS.GMF_GMFLCHST_XMLP_PKG dependencies on MTL_PARAMETERS

Line 133: MTL_PARAMETERS MP

129: MP.ORGANIZATION_CODE || ' ' || R.RECEIPT_NUM
130: FROM
131: RCV_SHIPMENT_HEADERS R,
132: MTL_MATERIAL_TRANSACTIONS P,
133: MTL_PARAMETERS MP
134: WHERE R.SHIPMENT_HEADER_ID = P.TRANSACTION_SOURCE_ID
135: AND R.ORGANIZATION_ID = P.ORGANIZATION_ID
136: AND P.TRANSACTION_SOURCE_ID = DOC_ID
137: AND P.TRX_SOURCE_LINE_ID = LINE_ID

Line 154: MTL_PARAMETERS MP,

150: SELECT
151: MP.ORGANIZATION_CODE || ' ' || MCC.COUNT_LIST_SEQUENCE
152: FROM
153: MTL_MATERIAL_TRANSACTIONS MTT,
154: MTL_PARAMETERS MP,
155: MTL_CYCLE_COUNT_ENTRIES MCC
156: WHERE MTT.CYCLE_COUNT_ID = DOC_ID
157: AND MP.ORGANIZATION_ID = MTT.ORGANIZATION_ID
158: AND MCC.CYCLE_COUNT_ENTRY_ID = MTT.CYCLE_COUNT_ID;

Line 164: MTL_PARAMETERS MP

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

Line 176: MTL_PARAMETERS MP,

172: WSH_NEW_DELIVERIES D,
173: MTL_MATERIAL_TRANSACTIONS T,
174: WSH_DELIVERY_DETAILS WD,
175: WSH_DELIVERY_ASSIGNMENTS WA,
176: MTL_PARAMETERS MP,
177: MTL_TXN_SOURCE_TYPES MTST,
178: ORG_ORGANIZATION_DEFINITIONS OOD
179: WHERE D.DELIVERY_ID = WA.DELIVERY_ID
180: AND WA.DELIVERY_DETAIL_ID = WD.DELIVERY_DETAIL_ID

Line 193: MTL_PARAMETERS MP,

189: SELECT
190: DISTINCT
191: '(Bill-Only) ' || MP.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
192: FROM
193: MTL_PARAMETERS MP,
194: MTL_MATERIAL_TRANSACTIONS T,
195: OE_ORDER_HEADERS_ALL OH,
196: OE_ORDER_LINES_ALL OL,
197: MTL_TXN_SOURCE_TYPES MTST,