DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 199: OE_ORDER_HEADERS_ALL OH,

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
203: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID

Line 217: OE_ORDER_HEADERS_ALL OH,

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
221: WHERE OOD.LEGAL_ENTITY = P_LEGAL_ENTITY_ID