DBA Data[Home] [Help]

APPS.OEXBMCBK dependencies on SO_ORDER_TYPES_ALL

Line 39: SO_ORDER_TYPES_ALL OETYP,

35:
36: SELECT OEORD.HEADER_ID
37: INTO header_id
38: FROM MTL_SALES_ORDERS MTLSO,
39: SO_ORDER_TYPES_ALL OETYP,
40: SO_HEADERS_ALL OEORD
41: WHERE MTLSO.SALES_ORDER_ID = dem_src_header
42: AND OETYP.NAME = MTLSO.SEGMENT2
43: AND OEORD.ORDER_NUMBER = TO_NUMBER( MTLSO.SEGMENT1 )