DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on MTL_TXN_SOURCE_TYPES

Line 181: MTL_TXN_SOURCE_TYPES MTST,

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

Line 201: MTL_TXN_SOURCE_TYPES MTST,

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
203: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
204: AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
205: AND T.TRANSACTION_SOURCE_ID = P_DOC_ID

Line 219: MTL_TXN_SOURCE_TYPES MTST,

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
221: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID
222: AND MTST.TRANSACTION_SOURCE_TYPE_NAME = 'Sales Order'
223: AND T.TRANSACTION_SOURCE_ID = P_DOC_ID