DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 196: OE_ORDER_LINES_ALL OL,

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

Line 214: OE_ORDER_LINES_ALL OL,

210: '(Drop-Ship) ' || OOD.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
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'