DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_STATUS_B

Line 1725: ZX_STATUS_B status

1721: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines
1722: AR_MEMO_LINES_ALL_B memoline,
1723: ZX_REGIMES_B regimes,
1724: ZX_TAXES_B taxes,
1725: ZX_STATUS_B status
1726: WHERE custtrx.customer_trx_id = p_upg_trx_info_rec.trx_id
1727: AND custtrx.customer_trx_id = custtrxl.customer_trx_id
1728: AND custtrx.previous_customer_trx_id = custtrx_prev.customer_trx_id(+)
1729: AND (case when (custtrxl.line_type IN ('LINE' ,'CB')) then custtrxl.customer_trx_line_id

Line 3505: ZX_STATUS_B status

3501: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the line for tax lines
3502: AR_MEMO_LINES_ALL_B memoline,
3503: ZX_REGIMES_B regimes,
3504: ZX_TAXES_B taxes,
3505: ZX_STATUS_B status
3506: WHERE zxvalerr.other_doc_application_id = 222
3507: AND custtrx.customer_trx_id = zxvalerr.other_doc_trx_id
3508: AND custtrx.customer_trx_id = custtrxl.customer_trx_id
3509: AND custtrx.previous_customer_trx_id = custtrx_prev.customer_trx_id(+)