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.RLM_CUM_SV dependencies on RLM_CUST_ITEM_CUM_ADJ

Line 933: FROM rlm_cust_item_cum_adj

929: AND inventory_item_id = x_cum_key_record.inventory_item_id;
930: --
931: SELECT NVL(SUM(transaction_qty), 0)
932: INTO adj_qty
933: FROM rlm_cust_item_cum_adj
934: WHERE cum_key_id = x_cum_record.cum_key_id
935: AND transaction_date_time >= x_cum_record.cum_start_date
936: AND transaction_date_time <= x_cum_record.as_of_date_time;
937: --

Line 1191: FROM rlm_cust_item_cum_adj

1187: AND inventory_item_id = x_cum_key_record.inventory_item_id;
1188: --
1189: SELECT NVL(SUM(transaction_qty), 0)
1190: INTO adj_qty
1191: FROM rlm_cust_item_cum_adj
1192: WHERE cum_key_id = x_cum_record.cum_key_id
1193: AND transaction_date_time >= x_cum_record.cum_start_date
1194: AND transaction_date_time <= v_cutoff_date;
1195: --

Line 3850: UPDATE rlm_cust_item_cum_adj

3846: x_index => v_shipLineCounter);
3847: --
3848: --set the cum_key_id from adjustment to be the new cum_key_id
3849:
3850: UPDATE rlm_cust_item_cum_adj
3851: SET cum_key_id = v_cum_records(v_index).cum_key_id
3852: WHERE cum_key_id = p_cum_key_id
3853: AND transaction_date_time <= nvl(v_end_date_time,sysdate)
3854: AND transaction_date_time >= x_transaction_start_date;

Line 3955: FROM rlm_cust_item_cum_adj

3951: IF v_adjustment_date IS NULL THEN
3952: --
3953: SELECT SUM(transaction_qty)
3954: INTO adj_qty
3955: FROM rlm_cust_item_cum_adj
3956: WHERE cum_key_id = v_cum_records(v_index).cum_key_id
3957: AND transaction_date_time <= sysdate;
3958: --
3959: ELSE

Line 3963: FROM rlm_cust_item_cum_adj

3959: ELSE
3960: --
3961: SELECT SUM(transaction_qty)
3962: INTO adj_qty
3963: FROM rlm_cust_item_cum_adj
3964: WHERE cum_key_id = v_cum_records(v_index).cum_key_id
3965: AND transaction_date_time >= v_adjustment_date
3966: AND transaction_date_time <= sysdate;
3967: --

Line 5271: FROM rlm_cust_item_cum_adj

5267: IF nvl(v_shipment_count,0) = 0 THEN --{
5268: --see if there are adjustments
5269: SELECT COUNT(*)
5270: INTO v_exist
5271: FROM rlm_cust_item_cum_adj
5272: WHERE cum_key_id = v_tmp_cum_record.cum_key_id
5273: AND transaction_date_time <= nvl(x_transaction_end_date,sysdate)
5274: AND transaction_date_time >= x_transaction_start_date;
5275: --

Line 5544: FROM rlm_cust_item_cum_adj

5540: IF x_adjustment_date IS NULL THEN
5541: --
5542: SELECT SUM(transaction_qty)
5543: INTO adj_qty
5544: FROM rlm_cust_item_cum_adj
5545: WHERE cum_key_id = x_cum_records(x_index).cum_key_id
5546: AND transaction_date_time <
5547: x_cum_records(x_index).actual_shipment_date;
5548: --

Line 5553: FROM rlm_cust_item_cum_adj

5549: ELSE
5550: --
5551: SELECT SUM(transaction_qty)
5552: INTO adj_qty
5553: FROM rlm_cust_item_cum_adj
5554: WHERE cum_key_id = x_cum_records(x_index).cum_key_id
5555: AND transaction_date_time >= x_adjustment_date
5556: AND transaction_date_time <
5557: x_cum_records(x_index).actual_shipment_date;

Line 6035: FROM rlm_cust_item_cum_adj

6031: --
6032: -- get all adjustments after the last shipment
6033: SELECT SUM(transaction_qty)
6034: INTO adj_qty
6035: FROM rlm_cust_item_cum_adj
6036: WHERE cum_key_id = x_old_cum_records(cum_records_counter).cum_key_id
6037: AND transaction_date_time <= sysdate
6038: AND ((transaction_date_time >= v_adjustment_date)
6039: OR (v_adjustment_date IS NULL));