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 929: FROM rlm_cust_item_cum_adj

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

Line 1182: FROM rlm_cust_item_cum_adj

1178: AND inventory_item_id = x_cum_key_record.inventory_item_id;
1179: --
1180: SELECT NVL(SUM(transaction_qty), 0)
1181: INTO adj_qty
1182: FROM rlm_cust_item_cum_adj
1183: WHERE cum_key_id = x_cum_record.cum_key_id
1184: AND transaction_date_time >= x_cum_record.cum_start_date
1185: AND transaction_date_time <= v_cutoff_date;
1186: --

Line 3840: UPDATE rlm_cust_item_cum_adj

3836: x_index => v_shipLineCounter);
3837: --
3838: --set the cum_key_id from adjustment to be the new cum_key_id
3839:
3840: UPDATE rlm_cust_item_cum_adj
3841: SET cum_key_id = v_cum_records(v_index).cum_key_id
3842: WHERE cum_key_id = p_cum_key_id
3843: AND transaction_date_time <= nvl(v_end_date_time,sysdate)
3844: AND transaction_date_time >= x_transaction_start_date;

Line 3945: FROM rlm_cust_item_cum_adj

3941: IF v_adjustment_date IS NULL THEN
3942: --
3943: SELECT SUM(transaction_qty)
3944: INTO adj_qty
3945: FROM rlm_cust_item_cum_adj
3946: WHERE cum_key_id = v_cum_records(v_index).cum_key_id
3947: AND transaction_date_time <= sysdate;
3948: --
3949: ELSE

Line 3953: FROM rlm_cust_item_cum_adj

3949: ELSE
3950: --
3951: SELECT SUM(transaction_qty)
3952: INTO adj_qty
3953: FROM rlm_cust_item_cum_adj
3954: WHERE cum_key_id = v_cum_records(v_index).cum_key_id
3955: AND transaction_date_time >= v_adjustment_date
3956: AND transaction_date_time <= sysdate;
3957: --

Line 5261: FROM rlm_cust_item_cum_adj

5257: IF nvl(v_shipment_count,0) = 0 THEN --{
5258: --see if there are adjustments
5259: SELECT COUNT(*)
5260: INTO v_exist
5261: FROM rlm_cust_item_cum_adj
5262: WHERE cum_key_id = v_tmp_cum_record.cum_key_id
5263: AND transaction_date_time <= nvl(x_transaction_end_date,sysdate)
5264: AND transaction_date_time >= x_transaction_start_date;
5265: --

Line 5534: FROM rlm_cust_item_cum_adj

5530: IF x_adjustment_date IS NULL THEN
5531: --
5532: SELECT SUM(transaction_qty)
5533: INTO adj_qty
5534: FROM rlm_cust_item_cum_adj
5535: WHERE cum_key_id = x_cum_records(x_index).cum_key_id
5536: AND transaction_date_time <
5537: x_cum_records(x_index).actual_shipment_date;
5538: --

Line 5543: FROM rlm_cust_item_cum_adj

5539: ELSE
5540: --
5541: SELECT SUM(transaction_qty)
5542: INTO adj_qty
5543: FROM rlm_cust_item_cum_adj
5544: WHERE cum_key_id = x_cum_records(x_index).cum_key_id
5545: AND transaction_date_time >= x_adjustment_date
5546: AND transaction_date_time <
5547: x_cum_records(x_index).actual_shipment_date;

Line 6025: FROM rlm_cust_item_cum_adj

6021: --
6022: -- get all adjustments after the last shipment
6023: SELECT SUM(transaction_qty)
6024: INTO adj_qty
6025: FROM rlm_cust_item_cum_adj
6026: WHERE cum_key_id = x_old_cum_records(cum_records_counter).cum_key_id
6027: AND transaction_date_time <= sysdate
6028: AND ((transaction_date_time >= v_adjustment_date)
6029: OR (v_adjustment_date IS NULL));