DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on MTL_TXN_SOURCE_TYPES

Line 177: MTL_TXN_SOURCE_TYPES MTST,

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
181: AND OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID

Line 197: MTL_TXN_SOURCE_TYPES MTST,

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,
198: ORG_ORGANIZATION_DEFINITIONS OOD
199: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
200: AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
201: AND T.TRANSACTION_SOURCE_ID = P_DOC_ID

Line 215: MTL_TXN_SOURCE_TYPES MTST,

211: FROM
212: MTL_MATERIAL_TRANSACTIONS T,
213: OE_ORDER_HEADERS_ALL OH,
214: OE_ORDER_LINES_ALL OL,
215: MTL_TXN_SOURCE_TYPES MTST,
216: ORG_ORGANIZATION_DEFINITIONS OOD
217: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
218: AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
219: AND T.TRANSACTION_SOURCE_ID = P_DOC_ID