DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_STATUS_B

Line 1151: zx_status_b status

1147: ap_tax_codes_all atc,
1148: zx_rates_b rates,
1149: zx_regimes_b regimes,
1150: zx_taxes_b taxes,
1151: zx_status_b status
1152: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
1153: AND poh.po_header_id = pol.po_header_id
1154: AND pol.po_header_id = poll.po_header_id
1155: AND pol.po_line_id = poll.po_line_id

Line 1866: zx_status_b status

1862: ap_tax_codes_all atc1,
1863: zx_rates_b rates,
1864: zx_regimes_b regimes,
1865: zx_taxes_b taxes,
1866: zx_status_b status
1867: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
1868: AND poh.po_header_id = pol.po_header_id
1869: AND pol.po_header_id = poll.po_header_id
1870: AND pol.po_line_id = poll.po_line_id

Line 3470: zx_status_b status

3466: ap_tax_codes_all atc,
3467: zx_rates_b rates,
3468: zx_regimes_b regimes,
3469: zx_taxes_b taxes,
3470: zx_status_b status
3471: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
3472: AND pol.po_header_id = poll.po_header_id
3473: AND pol.po_line_id = poll.po_line_id
3474: AND nvl(atc.org_id,-99)=nvl(poll.fsp_org_id,-99)

Line 4197: zx_status_b status

4193: ap_tax_codes_all atc1,
4194: zx_rates_b rates,
4195: zx_regimes_b regimes,
4196: zx_taxes_b taxes,
4197: zx_status_b status
4198: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
4199: AND pol.po_header_id = poll.po_header_id
4200: AND pol.po_line_id = poll.po_line_id
4201: AND nvl(atc.org_id,-99)=nvl(poll.fsp_org_id,-99)

Line 5859: zx_status_b status

5855: ap_tax_codes_all atc,
5856: zx_rates_b rates,
5857: zx_regimes_b regimes,
5858: zx_taxes_b taxes,
5859: zx_status_b status
5860: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
5861: AND poh.po_header_id = pol.po_header_id
5862: AND pol.po_header_id = poll.po_header_id
5863: AND pol.po_line_id = poll.po_line_id

Line 6572: zx_status_b status

6568: ap_tax_codes_all atc1,
6569: zx_rates_b rates,
6570: zx_regimes_b regimes,
6571: zx_taxes_b taxes,
6572: zx_status_b status
6573: WHERE NVL(poh.currency_code, poh.base_currency_code) = fc.currency_code(+)
6574: AND poh.po_header_id = pol.po_header_id
6575: AND pol.po_header_id = poll.po_header_id
6576: AND pol.po_line_id = poll.po_line_id

Line 8165: zx_status_b status

8161: ap_tax_codes_all atc,
8162: zx_rates_b rates,
8163: zx_regimes_b regimes,
8164: zx_taxes_b taxes,
8165: zx_status_b status
8166: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8167: AND pol.po_header_id = poll.po_header_id
8168: AND pol.po_line_id = poll.po_line_id
8169: AND NOT EXISTS

Line 8887: zx_status_b status

8883: ap_tax_codes_all atc1,
8884: zx_rates_b rates,
8885: zx_regimes_b regimes,
8886: zx_taxes_b taxes,
8887: zx_status_b status
8888: WHERE NVL(poll.poh_currency_code, poll.aps_base_currency_code) = fc.currency_code(+)
8889: AND pol.po_header_id = poll.po_header_id
8890: AND pol.po_line_id = poll.po_line_id
8891: AND NOT EXISTS