DBA Data[Home] [Help]

APPS.JE_ZZ_AUTO_INVOICE dependencies on ZX_LINES_DET_FACTORS

Line 64: UPDATE zx_lines_det_factors zxld

60: arp_standard.debug('JG Updating Tax Invoice Date ');
61:
62: BEGIN
63:
64: UPDATE zx_lines_det_factors zxld
65: SET zxld.tax_invoice_date = (SELECT MAX(trxd.gl_date)
66: FROM ra_cust_trx_line_gl_dist_all trxd
67: WHERE trxd.request_id= p_request_id
68: AND trxd.org_id= l_org_id