[Home] [Help]
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. |
1005: | |
1006: | Called from : Start_accrual_load Procedure |
1896: debug(' l_stmt_num :'||l_stmt_num);
1897: debug(' Upgrading miscellenaous INV WO detail data');
1898:
1899:
1900: /* Now insert into the cst_write_off details table */
1901: Insert into cst_write_off_details
1902: (
1903: write_off_id,
1904: rcv_transaction_id,
1897: debug(' Upgrading miscellenaous INV WO detail data');
1898:
1899:
1900: /* Now insert into the cst_write_off details table */
1901: Insert into cst_write_off_details
1902: (
1903: write_off_id,
1904: rcv_transaction_id,
1905: inventory_transaction_id,
1984: debug(' l_stmt_num :'||l_stmt_num);
1985: debug(' Updating the WO details for PO RCV');
1986:
1987: /* Insert details for PO data */
1988: Insert into cst_write_off_details
1989: (
1990: write_off_id,
1991: rcv_transaction_id,
1992: inventory_transaction_id,
2077: debug(' l_stmt_num :'||l_stmt_num);
2078: debug(' Updating WO details for AP Invoice');
2079:
2080:
2081: Insert into cst_write_off_details
2082: (
2083: write_off_id,
2084: rcv_transaction_id,
2085: inventory_transaction_id,
2523: FROM cst_write_offs cwo2
2524: WHERE cwo2.invoice_distribution_id is NOT NULL
2525: AND cwo2.invoice_distribution_id = aida.invoice_distribution_id
2526: AND cwo2.accrual_account_id = xla.code_combination_id
2527: AND EXISTS (Select 1 from cst_write_off_details cwod
2528: where cwod.write_off_id = cwo2.write_off_id
2529: and cwod.ae_header_id = xla.ae_header_id
2530: and cwod.ae_line_num = xla.ae_line_num
2531: )
2610: FROM cst_write_offs cwo2
2611: WHERE cwo2.invoice_distribution_id is NOT NULL
2612: AND cwo2.invoice_distribution_id = aida.invoice_distribution_id
2613: AND cwo2.accrual_account_id = xla.code_combination_id
2614: AND EXISTS (Select 1 from cst_write_off_details cwod
2615: where cwod.write_off_id = cwo2.write_off_id
2616: and cwod.ae_header_id = xla.ae_header_id
2617: and cwod.ae_line_num = xla.ae_line_num
2618: )
2915: FROM cst_write_offs cwo2
2916: WHERE cwo2.inventory_transaction_id is NOT NULL
2917: AND cwo2.inventory_transaction_id = mmt.transaction_id
2918: AND cwo2.accrual_account_id = xal.code_combination_id
2919: AND EXISTS ( Select 1 from cst_write_off_details cwod
2920: where cwod.write_off_id = cwo2.write_off_id
2921: and cwod.ae_header_id = xah.ae_header_id
2922: and cwod.ae_line_num = xal.ae_line_num
2923: )
3047: FROM cst_write_offs cwo2
3048: WHERE cwo2.inventory_transaction_id is NOT NULL
3049: AND cwo2.inventory_transaction_id = mmt.transaction_id
3050: AND cwo2.accrual_account_id = xal.code_combination_id
3051: AND EXISTS ( Select 1 from cst_write_off_details cwod
3052: where cwod.write_off_id = cwo2.write_off_id
3053: and cwod.ae_header_id = xah.ae_header_id
3054: and cwod.ae_line_num = xal.ae_line_num
3055: )
3130: FROM cst_write_offs cwo2
3131: WHERE cwo2.inventory_transaction_id is NOT NULL
3132: AND cwo2.inventory_transaction_id = mmt.transaction_id
3133: AND cwo2.accrual_account_id = xal.code_combination_id
3134: AND EXISTS ( Select 1 from cst_write_off_details cwod
3135: where cwod.write_off_id = cwo2.write_off_id
3136: and cwod.ae_header_id = xah.ae_header_id
3137: and cwod.ae_line_num = xal.ae_line_num
3138: )