[Home] [Help]
2502: cl.charge_amt * cl.currency_conversion_rate) AS ch_line_amt_func_curr,
2503: cl.currency_code,
2504: cl.charge_line_id,
2505: cl.charge_line_num
2506: FROM inl_adj_charge_lines_v cl,
2507: inl_associations assoc
2508: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
2509: AND assoc.from_parent_table_id = NVL (cl.parent_charge_line_id, cl.charge_line_id)
2510: AND assoc.ship_header_id = p_ship_header_id
6786: cl.poa_party_id ,
6787: cl.poa_party_site_id ,
6788: cl.poo_organization_id ,
6789: cl.poo_location_id
6790: FROM inl_adj_charge_lines_v cl,
6791: inl_associations a,
6792: inl_matches m
6793: WHERE
6794: ((cl.match_id IS NULL
7312: SUM(cl.charge_amt)
7313: INTO
7314: l_sum_chLnAmt
7315: FROM
7316: inl_adj_charge_lines_v cl,
7317: inl_adj_associations_v a, --BUG#9804065
7318: inl_ship_lines_all sl,
7319: inl_ship_line_groups slg,
7320: inl_ship_headers_all sh
7483: SUM(cl.charge_amt)
7484: INTO
7485: l_sum_chLnAmt
7486: FROM
7487: inl_adj_charge_lines_v cl,
7488: inl_associations a
7489: WHERE
7490: a.ship_header_id = affected_by_elc_lst(k).ship_header_id
7491: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7534: SUM(cl.charge_amt)
7535: INTO
7536: l_sum_chLnAmt
7537: FROM
7538: inl_adj_charge_lines_v cl,
7539: inl_associations a
7540: WHERE
7541: a.ship_header_id = affected_by_elc_lst(k).ship_header_id
7542: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7597: SUM(cl.charge_amt)
7598: INTO
7599: l_sum_chLnAmt
7600: FROM
7601: inl_adj_charge_lines_v cl,
7602: inl_associations a
7603: WHERE
7604: a.ship_header_id = affected_by_elc_lst(k).ship_header_id
7605: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
8139: INTO l_prev_adjustment_num ,
8140: l_ChLn_Assoc.parent_charge_line_id,
8141: l_ChLn_Assoc.charge_line_num
8142: FROM inl_matches m,
8143: inl_adj_charge_lines_v cl
8144: WHERE cl.match_id = m.match_id
8145: AND m.match_id <> p_match_id
8146: AND m.from_parent_table_name = l_from_parent_table_name
8147: AND m.from_parent_table_id = l_from_parent_table_id
8159: )
8160: AND cl.charge_line_num =
8161: (
8162: SELECT MAX (cl1.charge_line_num)
8163: FROM inl_adj_charge_lines_v cl1
8164: WHERE cl1.match_id = m.match_id
8165: ) ;
8166: -- GROUP BY cl.charge_line_id, cl.adjustment_num;
8167: ELSE
8179: cl.adjustment_num
8180: INTO l_corr_charge_line_id,
8181: l_corr_charge_line_num ,
8182: l_corr_adj_num
8183: FROM inl_adj_charge_lines_v cl
8184: WHERE cl.match_id = p_match_id
8185: AND cl.charge_line_num =
8186: (
8187: SELECT MAX (cl1.charge_line_num)
8184: WHERE cl.match_id = p_match_id
8185: AND cl.charge_line_num =
8186: (
8187: SELECT MAX (cl1.charge_line_num)
8188: FROM inl_adj_charge_lines_v cl1
8189: WHERE cl1.match_id = p_match_id
8190: ) ;
8191: EXCEPTION
8192: WHEN NO_DATA_FOUND THEN
8709: cl.charge_line_num
8710: INTO l_ChLn_Assoc.parent_charge_line_id,
8711: l_ChLn_Assoc.charge_line_num
8712: FROM inl_matches m,
8713: inl_adj_charge_lines_v cl
8714: WHERE cl.match_amount_id = m.match_amount_id
8715: AND m.from_parent_table_name = l_from_parent_table_name
8716: AND m.from_parent_table_id = l_from_parent_table_id
8717: AND m.to_parent_table_name = l_to_parent_table_name
8729: )
8730: AND cl.charge_line_num =
8731: (
8732: SELECT MAX (cl1.charge_line_num)
8733: FROM inl_adj_charge_lines_v cl1
8734: WHERE cl1.match_amount_id = m.match_amount_id
8735: ) ;
8736: -- GROUP BY cl.charge_line_id, cl.adjustment_num;
8737: ELSE
8751: INTO
8752: l_corr_charge_line_id ,
8753: l_corr_charge_line_num,
8754: l_corr_adj_num
8755: FROM inl_adj_charge_lines_v cl
8756: WHERE cl.match_amount_id = p_match_amount_id
8757: AND cl.charge_line_num =
8758: (
8759: SELECT MAX (cl1.charge_line_num)
8756: WHERE cl.match_amount_id = p_match_amount_id
8757: AND cl.charge_line_num =
8758: (
8759: SELECT MAX (cl1.charge_line_num)
8760: FROM inl_adj_charge_lines_v cl1
8761: WHERE cl1.match_amount_id = p_match_amount_id
8762: ) ;
8763: EXCEPTION
8764: WHEN NO_DATA_FOUND THEN
11144: -- Get ELC Adjustments for Charge Lines
11145: CURSOR c_elc_adj_chlines IS
11146: SELECT DISTINCT charge_line_id
11147: FROM inl_ship_headers_all sh,
11148: inl_adj_charge_lines_v cl,
11149: inl_adj_associations_v a
11150: WHERE sh.ship_header_id = a.ship_header_id
11151: AND a.from_parent_table_id = cl.charge_line_id
11152: AND sh.pending_update_flag = 'Y'
11559: NULL, -- 44
11560: NULL, -- 45
11561: NULL, -- 46
11562: NULL -- 47
11563: FROM inl_adj_charge_lines_v cl
11564: WHERE cl.charge_line_id = l_elc_adj_chlines(i).charge_line_id);
11565:
11566: l_debug_info := 'Create associations for charge line ID: ' || l_charge_line_id;
11567: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
11706: NULL, -- 45
11707: NULL, -- 46
11708: NULL, -- 47
11709: 'Z' -- 48
11710: FROM inl_adj_charge_lines_v cl
11711: WHERE cl.charge_line_id = l_elc_adj_chlines(i).charge_line_id);
11712: ELSE -- associations were not changed
11713: l_debug_info := 'Associations were not changed. Charge line ID: ' || l_elc_adj_chlines(i).charge_line_id;
11714: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
11717:
11718: -- Check if charge was changed
11719: SELECT COUNT(1)
11720: INTO l_count_charge_changed
11721: FROM inl_adj_charge_lines_v c
11722: WHERE (c.new_charge_amt IS NOT NULL
11723: OR c.new_currency_conversion_type IS NOT NULL
11724: OR c.new_currency_conversion_date IS NOT NULL
11725: OR c.new_currency_conversion_rate IS NOT NULL)
11826: NULL, -- 44
11827: NULL, -- 45
11828: NULL, -- 46
11829: NULL -- 47
11830: FROM inl_adj_charge_lines_v cl
11831: WHERE cl.charge_line_id = l_elc_adj_chlines(i).charge_line_id);
11832: END IF;
11833: END IF;
11834: END LOOP;