APPS.GMF_GMFLCHST_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 136: MTL_MATERIAL_TRANSACTIONS P,

132: DISTINCT
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

Line 157: MTL_MATERIAL_TRANSACTIONS MTT,

153: CURSOR CUR_GET_CYCL IS
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

Line 167: MTL_MATERIAL_TRANSACTIONS MMT,

163: CURSOR CUR_GET_XFER IS
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

Line 177: MTL_MATERIAL_TRANSACTIONS T,

173: DISTINCT
174: MP.ORGANIZATION_CODE || ' ' || D.NAME
175: FROM
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,

Line 198: MTL_MATERIAL_TRANSACTIONS T,

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,
202: ORG_ORGANIZATION_DEFINITIONS OOD

Line 216: MTL_MATERIAL_TRANSACTIONS T,

212: SELECT
213: DISTINCT
214: '(Drop-Ship) ' || OOD.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
215: FROM
216: MTL_MATERIAL_TRANSACTIONS T,
217: OE_ORDER_HEADERS_ALL OH,
218: OE_ORDER_LINES_ALL OL,
219: MTL_TXN_SOURCE_TYPES MTST,
220: ORG_ORGANIZATION_DEFINITIONS OOD