DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on PO_ACCRUAL_WRITE_OFFS_ALL

Line 1024: | transactions from the old PO_ACCRUAL_WRITE_OFFS_ALL |

1020: | |
1021: | Purpose : This Procedure has all the necessary code to upgrade |
1022: | old write off data into the new tables. |
1023: | This procedure upgrades PO,AP and Inventory Write off |
1024: | transactions from the old PO_ACCRUAL_WRITE_OFFS_ALL |
1025: | table into the new CST_WRITE_OFFS and |
1026: | CST_WRITE_OFF_DETAILS table.This upgrade is done only |
1027: | for the very first run of the load program for the |
1028: | given OU.The old WIP write off data is not Upgraded. |

Line 1155: po_accrual_write_offs_all pawo,

1151: pawo.program_application_id,
1152: pawo.program_id,
1153: pawo.program_update_date
1154: FROM
1155: po_accrual_write_offs_all pawo,
1156: rcv_receiving_sub_ledger rrs,
1157: xla_distribution_links xld, --BUG#7275286
1158: rcv_transactions rt,
1159: po_headers_all poh

Line 1275: po_accrual_write_offs_all pawo,

1271: pawo.program_application_id,
1272: pawo.program_id,
1273: pawo.program_update_date
1274: FROM
1275: po_accrual_write_offs_all pawo,
1276: ap_invoice_distributions_all aida,
1277: financials_system_params_all fsp,
1278: gl_sets_of_books gsob,
1279: fnd_currencies fc,

Line 1409: po_accrual_write_offs_all pawo,

1405: pawo.program_application_id,
1406: pawo.program_id,
1407: pawo.program_update_date
1408: FROM
1409: po_accrual_write_offs_all pawo,
1410: ap_invoice_distributions_all aida,
1411: financials_system_params_all fsp,
1412: gl_sets_of_books gsob,
1413: fnd_currencies fc,

Line 1552: po_accrual_write_offs_all pawo,

1548: pawo.program_application_id,
1549: pawo.program_id,
1550: pawo.program_update_date
1551: FROM
1552: po_accrual_write_offs_all pawo,
1553: po_distributions_all pod,
1554: po_releases_all pra,
1555: po_headers_all poh,
1556: ap_invoice_distributions_all aida,

Line 1719: po_accrual_write_offs_all pawo,

1715: pawo.program_application_id,
1716: pawo.program_id,
1717: pawo.program_update_date
1718: FROM
1719: po_accrual_write_offs_all pawo,
1720: po_distributions_all pod,
1721: po_releases_all pra,
1722: po_headers_all poh,
1723: ap_invoice_distributions_all aida,

Line 1868: FROM po_accrual_write_offs_all pawo,

1864: pawo.request_id,
1865: pawo.program_application_id,
1866: pawo.program_id,
1867: pawo.program_update_date
1868: FROM po_accrual_write_offs_all pawo,
1869: mtl_transaction_accounts mta,
1870: xla_distribution_links xld
1871: ,cst_accrual_accounts ca --BUG#7528609
1872: WHERE pawo.transaction_source_code = 'INV'

Line 1972: po_accrual_write_offs_all pawo,

1968: cwo.program_application_id,
1969: cwo.program_id,
1970: cwo.program_update_date
1971: FROM cst_write_offs cwo,
1972: po_accrual_write_offs_all pawo,
1973: mtl_transaction_accounts mta,
1974: xla_distribution_links xld,
1975: cst_accrual_accounts ca --BUG7528609
1976: WHERE pawo.org_id = p_operating_unit

Line 2049: po_accrual_write_offs_all pawo,

2045: cwo.program_application_id,
2046: cwo.program_id,
2047: cwo.program_update_date
2048: FROM cst_write_offs cwo,
2049: po_accrual_write_offs_all pawo,
2050: po_lookup_codes plc,
2051: rcv_receiving_sub_ledger rrs,
2052: rcv_transactions rt,
2053: xla_distribution_links xld,

Line 2131: po_accrual_write_offs_all pawo,

2127: cwo.program_application_id,
2128: cwo.program_id,
2129: cwo.program_update_date
2130: FROM cst_write_offs cwo,
2131: po_accrual_write_offs_all pawo,
2132: po_lookup_codes plc,
2133: ap_invoice_distributions_all aida,
2134: ap_ae_lines_all aal,
2135: cst_accrual_accounts ca, --BUG#7528609