APPS.CST_ACCRUAL_LOAD dependencies on PO_ACCRUAL_WRITE_OFFS_ALL

Line 1000: | transactions from the old PO_ACCRUAL_WRITE_OFFS_ALL |

996: | |
997: | Purpose : This Procedure has all the necessary code to upgrade |
998: | old write off data into the new tables. |
999: | This procedure upgrades PO,AP and Inventory Write off |
1000: | transactions from the old PO_ACCRUAL_WRITE_OFFS_ALL |
1001: | table into the new CST_WRITE_OFFS and |
1002: | CST_WRITE_OFF_DETAILS table.This upgrade is done only |
1003: | for the very first run of the load program for the |
1004: | given OU.The old WIP write off data is not Upgraded. |

Line 1130: po_accrual_write_offs_all pawo,

1126: pawo.program_application_id,
1127: pawo.program_id,
1128: pawo.program_update_date
1129: FROM
1130: po_accrual_write_offs_all pawo,
1131: rcv_receiving_sub_ledger rrs,
1132: xla_distribution_links xld, --BUG#7275286
1133: rcv_transactions rt,
1134: po_headers_all poh

Line 1253: po_accrual_write_offs_all pawo,

1249: pawo.program_application_id,
1250: pawo.program_id,
1251: pawo.program_update_date
1252: FROM
1253: po_accrual_write_offs_all pawo,
1254: ap_invoice_distributions_all aida,
1255: financials_system_params_all fsp,
1256: gl_sets_of_books gsob,
1257: fnd_currencies fc,

Line 1388: po_accrual_write_offs_all pawo,

1384: pawo.program_application_id,
1385: pawo.program_id,
1386: pawo.program_update_date
1387: FROM
1388: po_accrual_write_offs_all pawo,
1389: ap_invoice_distributions_all aida,
1390: financials_system_params_all fsp,
1391: gl_sets_of_books gsob,
1392: fnd_currencies fc,

Line 1532: po_accrual_write_offs_all pawo,

1528: pawo.program_application_id,
1529: pawo.program_id,
1530: pawo.program_update_date
1531: FROM
1532: po_accrual_write_offs_all pawo,
1533: po_distributions_all pod,
1534: po_releases_all pra,
1535: po_headers_all poh,
1536: ap_invoice_distributions_all aida,

Line 1700: po_accrual_write_offs_all pawo,

1696: pawo.program_application_id,
1697: pawo.program_id,
1698: pawo.program_update_date
1699: FROM
1700: po_accrual_write_offs_all pawo,
1701: po_distributions_all pod,
1702: po_releases_all pra,
1703: po_headers_all poh,
1704: ap_invoice_distributions_all aida,

Line 1849: FROM po_accrual_write_offs_all pawo,

1845: pawo.request_id,
1846: pawo.program_application_id,
1847: pawo.program_id,
1848: pawo.program_update_date
1849: FROM po_accrual_write_offs_all pawo,
1850: mtl_transaction_accounts mta,
1851: xla_distribution_links xld
1852: ,cst_accrual_accounts ca --BUG#7528609
1853: WHERE pawo.transaction_source_code = 'INV'

Line 1963: po_accrual_write_offs_all pawo,

1959: ,xld.ae_header_id
1960: ,xld.ae_line_num
1961: --}
1962: FROM cst_write_offs cwo,
1963: po_accrual_write_offs_all pawo,
1964: mtl_transaction_accounts mta,
1965: xla_distribution_links xld,
1966: cst_accrual_accounts ca --BUG7528609
1967: WHERE pawo.org_id = p_operating_unit

Line 2050: po_accrual_write_offs_all pawo,

2046: ,xld.ae_header_id
2047: ,xld.ae_line_num
2048: --}
2049: FROM cst_write_offs cwo,
2050: po_accrual_write_offs_all pawo,
2051: po_lookup_codes plc,
2052: rcv_receiving_sub_ledger rrs,
2053: rcv_transactions rt,
2054: xla_distribution_links xld,

Line 2143: po_accrual_write_offs_all pawo,

2139: ,MAX(xld.ae_header_id)
2140: ,MAX(xld.ae_line_num)
2141: --}
2142: FROM cst_write_offs cwo,
2143: po_accrual_write_offs_all pawo,
2144: po_lookup_codes plc,
2145: ap_invoice_distributions_all aida,
2146: ap_ae_lines_all aal,
2147: cst_accrual_accounts ca, --BUG#7528609