[Home] [Help]
794:
795: -- Bug 12630218
796: CURSOR c_group_lines IS
797: SELECT slg.ship_line_group_id, slg.ship_line_group_num, COUNT(ol.ship_line_id) count_ship_line
798: FROM inl_ship_line_groups slg,
799: inl_adj_ship_lines_v ol
800: WHERE ol.ship_header_id (+) = slg.ship_header_id
801: AND ol.ship_line_group_id (+) = slg.ship_line_group_id
802: AND slg.ship_header_id = p_ship_header_id
2783: Handle_ShipError (
2784: p_ship_header_id => p_ship_header_id,
2785: p_ship_line_id => NULL,
2786: p_charge_line_id => NULL,
2787: p_table_name => 'INL_SHIP_LINE_GROUPS',
2788: p_column_name => 'PARTY_SITE_ID',
2789: p_column_value => p_party_site_id,
2790: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2791: p_msg_index => FND_MSG_PUB.Count_Msg (),
3073: Handle_ShipError (
3074: p_ship_header_id => p_ship_header_id,
3075: p_ship_line_id => NULL,
3076: p_charge_line_id => NULL,
3077: p_table_name => 'INL_SHIP_LINE_GROUPS',
3078: p_column_name => 'PARTY_ID',
3079: p_column_value => p_party_id,
3080: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3081: p_msg_index => FND_MSG_PUB.Count_Msg (),
3181: Handle_ShipError (
3182: p_ship_header_id => p_ship_header_id,
3183: p_ship_line_id => NULL,
3184: p_charge_line_id => NULL,
3185: p_table_name => 'INL_SHIP_LINE_GROUPS',
3186: p_column_name => 'PARTY_ID',
3187: p_column_value => p_party_id,
3188: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3189: p_msg_index => FND_MSG_PUB.Count_Msg (),
3345: Handle_ShipError (
3346: p_ship_header_id => p_ship_header_id,
3347: p_ship_line_id => NULL,
3348: p_charge_line_id => NULL,
3349: p_table_name => 'INL_SHIP_LINE_GROUPS',
3350: p_column_name => 'PARTY_SITE_ID',
3351: p_column_value => p_party_site_id,
3352: p_error_message => SUBSTR (FND_MSG_PUB.Get (
3353: p_msg_index => FND_MSG_PUB.Count_Msg (),
3669:
3670: SELECT isl.ship_line_num, islg.ship_line_group_num
3671: INTO l_ship_line_num,l_ship_ln_grp_num
3672: FROM inl_ship_lines isl,
3673: inl_ship_line_groups islg
3674: WHERE isl.ship_line_group_id=islg.ship_line_group_id
3675: AND isl.ship_line_id = l_ship_lines_rec.ship_line_id
3676: AND isl.ship_header_id = p_ship_header_id;
3677:
3928: l_group_line_num NUMBER; --Bug #12630218
3929: CURSOR c_ln_group IS
3930: SELECT ship_line_group_num, ship_line_group_id, lg.party_id, lg.party_site_id,
3931: lg.ship_line_group_reference, hps.party_site_name
3932: FROM inl_ship_line_groups lg,
3933: hz_party_sites hps
3934: WHERE hps.party_site_id = lg.party_site_id
3935: AND ship_header_id = p_ship_header_id
3936: ORDER BY ship_line_group_num;
6817: (m.to_parent_table_name = 'INL_SHIP_HEADERS'
6818: AND a.to_parent_table_name = 'INL_SHIP_HEADERS'
6819: AND m.ship_header_id = a.ship_header_id)
6820: OR
6821: (m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6822: AND m.ship_header_id = a.ship_header_id
6823: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6824: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6825: AND a.to_parent_table_id = m.to_parent_table_id)
6820: OR
6821: (m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6822: AND m.ship_header_id = a.ship_header_id
6823: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6824: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6825: AND a.to_parent_table_id = m.to_parent_table_id)
6826: )
6827: )
6828: OR
6828: OR
6829: (m.to_parent_table_name = 'INL_SHIP_LINES'
6830: AND m.ship_header_id = a.ship_header_id
6831: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6832: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6833: AND EXISTS (SELECT 1
6834: FROM inl_ship_lines sl
6835: WHERE sl.ship_line_id = m.to_parent_table_id -- the match ship line
6836: AND sl.ship_line_group_id = a.to_parent_table_id --belong to group of association
7104: FROM
7105: inl_charge_lines cl,
7106: inl_associations a,
7107: inl_ship_lines_all sl,
7108: inl_ship_line_groups slg,
7109: inl_ship_headers_all sh
7110: WHERE
7111: cl.adjustment_num = 0
7112: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
7115: AND a.ship_header_id = sl.ship_header_id
7116: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'
7117: AND a.to_parent_table_id = sl.ship_line_id)
7118: OR
7119: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7120: AND a.to_parent_table_id = sl.ship_line_group_id)
7121: OR
7122: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
7123: AND a.to_parent_table_id = sl.ship_header_id))
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
7321: WHERE
7322: a.ship_header_id = sl.ship_header_id
7323: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7323: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7324: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'
7325: AND a.to_parent_table_id = sl.ship_line_id)
7326: OR
7327: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7328: AND a.to_parent_table_id = sl.ship_line_group_id)
7329: OR
7330: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
7331: AND a.to_parent_table_id = sl.ship_header_id))
7528: START WITH cl1.charge_line_id = cl.charge_line_id
7529: CONNECT BY PRIOR cl1.parent_charge_line_id = cl1.charge_line_id));
7530: --Bug#11064618
7531:
7532: ELSIF affected_by_elc_lst(k).to_parent_table_name = 'INL_SHIP_LINE_GROUPS' then
7533: SELECT
7534: SUM(cl.charge_amt)
7535: INTO
7536: l_sum_chLnAmt
13465: WHERE ship_header_id = p_ship_header_id;
13466:
13467: SELECT NVL(MAX(last_update_date), min_date)
13468: INTO l_group_last_update_date
13469: FROM inl_ship_line_groups
13470: WHERE ship_header_id = p_ship_header_id;
13471:
13472: SELECT NVL(MAX(last_update_date), min_date)
13473: INTO l_line_last_update_date