DBA Data[Home] [Help]

APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 195: OE_ORDER_HEADERS_ALL OH,

191: '(Bill-Only) ' || MP.ORGANIZATION_CODE || ' ' || OH.ORDER_NUMBER
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

Line 213: OE_ORDER_HEADERS_ALL OH,

209: DISTINCT
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