eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCRUAL_LOAD dependencies on CST_WRITE_OFF_DETAILS

Line 1026: | CST_WRITE_OFF_DETAILS table.This upgrade is done only |

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. |
1029: | |
1030: | Called from : Start_accrual_load Procedure |

Line 1919: /* Now insert into the cst_write_off details table */

1915: debug(' l_stmt_num :'||l_stmt_num);
1916: debug(' Upgrading miscellenaous INV WO detail data');
1917:
1918:
1919: /* Now insert into the cst_write_off details table */
1920: Insert into cst_write_off_details
1921: (
1922: write_off_id,
1923: rcv_transaction_id,

Line 1920: Insert into cst_write_off_details

1916: debug(' Upgrading miscellenaous INV WO detail data');
1917:
1918:
1919: /* Now insert into the cst_write_off details table */
1920: Insert into cst_write_off_details
1921: (
1922: write_off_id,
1923: rcv_transaction_id,
1924: inventory_transaction_id,

Line 1997: Insert into cst_write_off_details

1993: debug(' l_stmt_num :'||l_stmt_num);
1994: debug(' Updating the WO details for PO RCV');
1995:
1996: /* Insert details for PO data */
1997: Insert into cst_write_off_details
1998: (
1999: write_off_id,
2000: rcv_transaction_id,
2001: inventory_transaction_id,

Line 2079: Insert into cst_write_off_details

2075: debug(' l_stmt_num :'||l_stmt_num);
2076: debug(' Updating WO details for AP Invoice');
2077:
2078:
2079: Insert into cst_write_off_details
2080: (
2081: write_off_id,
2082: rcv_transaction_id,
2083: inventory_transaction_id,

Line 2457: AND EXISTS (Select 1 from cst_write_off_details cwod

2453: FROM cst_write_offs cwo2
2454: WHERE cwo2.invoice_distribution_id is NOT NULL
2455: AND cwo2.invoice_distribution_id = aida.invoice_distribution_id
2456: AND cwo2.accrual_account_id = xal.code_combination_id
2457: AND EXISTS (Select 1 from cst_write_off_details cwod
2458: where cwod.write_off_id = cwo2.write_off_id
2459: and cwod.ae_header_id = xah.ae_header_id
2460: and cwod.ae_line_num = xal.ae_line_num
2461: )

Line 2708: AND EXISTS ( Select 1 from cst_write_off_details cwod

2704: FROM cst_write_offs cwo2
2705: WHERE cwo2.inventory_transaction_id is NOT NULL
2706: AND cwo2.inventory_transaction_id = mmt.transaction_id
2707: AND cwo2.accrual_account_id = xal.code_combination_id
2708: AND EXISTS ( Select 1 from cst_write_off_details cwod
2709: where cwod.write_off_id = cwo2.write_off_id
2710: and cwod.ae_header_id = xah.ae_header_id
2711: and cwod.ae_line_num = xal.ae_line_num
2712: )

Line 2835: AND EXISTS ( Select 1 from cst_write_off_details cwod

2831: FROM cst_write_offs cwo2
2832: WHERE cwo2.inventory_transaction_id is NOT NULL
2833: AND cwo2.inventory_transaction_id = mmt.transaction_id
2834: AND cwo2.accrual_account_id = xal.code_combination_id
2835: AND EXISTS ( Select 1 from cst_write_off_details cwod
2836: where cwod.write_off_id = cwo2.write_off_id
2837: and cwod.ae_header_id = xah.ae_header_id
2838: and cwod.ae_line_num = xal.ae_line_num
2839: )