DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 200: OE_ORDER_LINES_ALL OL,

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

Line 218: OE_ORDER_LINES_ALL OL,

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