APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on ZX_STATUS_B

Line 2148: ZX_STATUS_B status

2144: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines
2145: AR_MEMO_LINES_ALL_B memoline,
2146: ZX_REGIMES_B regimes,
2147: ZX_TAXES_B taxes,
2148: ZX_STATUS_B status
2149: WHERE custtrx.rowid BETWEEN p_start_rowid AND p_end_rowid
2150: AND custtrx.customer_trx_id = custtrxl.customer_trx_id
2151: AND custtrx.previous_customer_trx_id = custtrx_prev.customer_trx_id(+)
2152: AND upd.ledger_id = custtrx.set_of_books_id

Line 3588: use_nl_with_index(status ZX_STATUS_B_U2)

3584: use_nl_with_index(lines AP_INVOICE_LINES_U1)
3585: use_nl_with_index(taxes ZX_TAXES_B_U2)
3586: use_nl_with_index(rates ZX_RATES_B_N2)
3587: use_nl_with_index(regimes ZX_REGIMES_B_U2)
3588: use_nl_with_index(status ZX_STATUS_B_U2)
3589: use_nl_with_index(ptp ZX_PARTY_TAX_PROFILE_U2) */
3590: NVL(lines1.org_id,-99) INTERNAL_ORGANIZATION_ID
3591: ,DECODE(inv.INVOICE_TYPE_LOOKUP_CODE,
3592: 'STANDARD', 'STANDARD INVOICES', --Bug 5859937

Line 3821: zx_status_b status,

3817: ap_invoice_lines_all lines,
3818: zx_rates_b rates,
3819: zx_regimes_b regimes,
3820: zx_taxes_b taxes,
3821: zx_status_b status,
3822: zx_party_tax_profile ptp
3823: WHERE inv.rowid BETWEEN p_start_rowid AND p_end_rowid
3824: AND upd.ledger_id = inv.set_of_books_id
3825: AND (TRUNC(inv.invoice_date) between upd.start_date and upd.end_date)

Line 5018: zx_status_b status

5014: ar_tax_group_codes_all atg,
5015: zx_rates_b rates,
5016: zx_regimes_b regimes,
5017: zx_taxes_b taxes,
5018: zx_status_b status
5019: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5020: AND poh.po_header_id = pol.po_header_id
5021: AND pol.po_header_id = poll.po_header_id
5022: AND pol.po_line_id = poll.po_line_id