APPS.OE_BULK_VALIDATE dependencies on OE_PRICE_ADJS_INTERFACE

Line 245: FROM OE_HEADERS_IFACE_ALL h, OE_PRICE_ADJS_INTERFACE l

241: ,660 ,NULL ,NULL
242: ,NULL ,NULL ,NULL
243: ,'C' ,USERENV('LANG')
244: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
245: FROM OE_HEADERS_IFACE_ALL h, OE_PRICE_ADJS_INTERFACE l
246: WHERE h.batch_id = p_batch_id
247: AND h.order_source_id = l.order_source_id
248: AND h.orig_sys_document_ref = l.orig_sys_document_ref
249: AND l.orig_sys_discount_ref IS NULL;

Line 1968: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

1964: ,a.change_sequence ,NULL ,NULL ,NULL ,'APPLIED_FLAG'
1965: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1966: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1967: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1968: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
1969: WHERE h.batch_id = p_batch_id
1970: AND a.order_source_id = h.order_source_id
1971: AND a.orig_sys_document_ref = h.orig_sys_document_ref
1972: AND a.APPLIED_FLAG IS NOT NULL

Line 2004: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2000: ,a.change_sequence ,NULL ,NULL ,NULL ,'INCLUDE_ON_RETURNS_FLAG'
2001: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2002: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2003: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2004: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2005: WHERE h.batch_id = p_batch_id
2006: AND a.order_source_id = h.order_source_id
2007: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2008: AND a.INCLUDE_ON_RETURNS_FLAG IS NOT NULL

Line 2040: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2036: ,a.change_sequence ,NULL ,NULL ,NULL ,'CREDIT_OR_CHARGE_FLAG'
2037: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2039: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2040: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2041: WHERE h.batch_id = p_batch_id
2042: AND a.order_source_id = h.order_source_id
2043: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2044: AND a.CREDIT_OR_CHARGE_FLAG IS NOT NULL

Line 2079: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2075: ,a.change_sequence ,NULL ,NULL ,NULL ,'CHARGE_TYPE_CODE'
2076: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2077: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2078: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2079: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2080: WHERE h.batch_id = p_batch_id
2081: AND a.order_source_id = h.order_source_id
2082: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2083: AND a.CHARGE_TYPE_CODE IS NOT NULL

Line 2121: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2117: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_HEADER_ID'
2118: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2119: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2120: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2121: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2122: WHERE h.batch_id = p_batch_id
2123: AND a.order_source_id = h.order_source_id
2124: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2125: AND a.list_header_id IS NOT NULL

Line 2159: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2155: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_LINE_ID'
2156: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2157: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2158: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2159: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2160: WHERE h.batch_id = p_batch_id
2161: AND a.order_source_id = h.order_source_id
2162: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2163: AND a.list_line_id IS NOT NULL