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.INL_SHIPMENT_PVT dependencies on INL_ASSOCIATIONS

Line 2507: inl_associations assoc

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
2511: AND assoc.to_parent_table_name = p_to_parent_table_name

Line 3480: FROM inl_associations ia

3476: IF p_alloc_enabled_flag = 'N' THEN
3477: -- Check if ship lines is associable to other line
3478: SELECT NVL(COUNT(1),0)
3479: INTO l_count_associations
3480: FROM inl_associations ia
3481: WHERE ship_header_id = p_ship_header_id
3482: AND ia.from_parent_table_name = 'INL_SHIP_LINES'
3483: AND ia.from_parent_table_id = p_ship_line_id;
3484:

Line 4560: l_debug_info := 'Insert in inl_associations.';

4556: p_module_name => g_module_name,
4557: p_procedure_name => l_program_name) ;
4558: -- Initialize return status to success
4559: x_return_status := L_FND_RET_STS_SUCCESS;
4560: l_debug_info := 'Insert in inl_associations.';
4561: INL_LOGGING_PVT.Log_Statement (
4562: p_module_name => g_module_name,
4563: p_procedure_name => l_program_name,
4564: p_debug_info => l_debug_info) ;

Line 4575: INTO inl_associations (

4571:
4572: IF p_Assoc.association_id IS NULL THEN
4573: l_debug_info := 'Including association';
4574: INSERT
4575: INTO inl_associations (
4576: association_id, /* 01 */
4577: ship_header_id, /* 02 */
4578: from_parent_table_name, /* 03 */
4579: from_parent_table_id, /* 04 */

Line 4591: inl_associations_s.nextval, /* 01 */

4587: last_update_date, /* 12 */
4588: last_update_login /* 13 */
4589: )
4590: VALUES (
4591: inl_associations_s.nextval, /* 01 */
4592: p_Assoc.ship_header_id, /* 02 */
4593: p_from_parent_table_name, /* 03 */
4594: p_new_line_id, /* 04 */
4595: p_Assoc.to_parent_table_name, /* 05 */

Line 4607: UPDATE inl_associations

4603: l_fnd_login_id /* 13 */ --SCM-051
4604: );
4605: ELSE
4606: l_debug_info := 'Updating association';
4607: UPDATE inl_associations
4608: SET
4609: ship_header_id = p_Assoc.ship_header_id ,
4610: from_parent_table_name = p_from_parent_table_name ,
4611: from_parent_table_id = p_new_line_id ,

Line 4932: inl_associations assoc

4928: tl.currency_conversion_rate,
4929: tl.tax_amt_included_flag
4930: FROM
4931: inl_adj_tax_lines_v tl,
4932: inl_associations assoc
4933: WHERE p_ship_header_id IS NULL
4934: AND (tl.tax_amt > 0
4935: OR tl.nrec_tax_amt > 0) --SCM-051
4936: AND (tl.adjustment_num = p_prev_adjustment_num

Line 6283: FROM inl_associations assoc

6279: INTO l_charge_line_num
6280: FROM inl_charge_lines cl
6281: WHERE EXISTS
6282: (SELECT 1
6283: FROM inl_associations assoc
6284: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
6285: AND assoc.from_parent_table_id = cl.charge_line_id
6286: AND assoc.ship_header_id
6287: IN (select m1.ship_header_id

Line 6301: FROM inl_associations assoc

6297: FROM inl_charge_lines cl
6298: WHERE NVL (cl.parent_charge_line_id, cl.charge_line_id) IN
6299: (
6300: SELECT assoc.from_parent_table_id
6301: FROM inl_associations assoc
6302: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
6303: AND assoc.ship_header_id = NVL (p_ChLn_Assoc.inl_Assoc.ship_header_id, 0)
6304: ) ;
6305: END IF;

Line 6791: inl_associations a,

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
6795: AND cl.match_amount_id IS NULL)

Line 7051: inl_associations a

7047: a.ship_header_id ,
7048: a.to_parent_table_name,
7049: a.to_parent_table_id
7050: FROM
7051: inl_associations a
7052: WHERE
7053: a.from_parent_table_name = 'INL_CHARGE_LINES'
7054: AND a.from_parent_table_id = pc_charge_line_id
7055: ;

Line 7106: inl_associations a,

7102: a.to_parent_table_name ,
7103: a.to_parent_table_id
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

Line 7365: inl_associations assoc

7361: INTO
7362: l_alc_zero
7363: FROM
7364: inl_charge_lines cl,
7365: inl_associations assoc
7366: WHERE
7367: assoc.to_parent_table_id = affected_by_alc_ship_lst(i).to_parent_table_id
7368: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7369: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'

Line 7488: inl_associations a

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
7492: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC

Line 7511: inl_associations assoc

7507: INTO
7508: l_alc_zero
7509: FROM
7510: inl_charge_lines cl,
7511: inl_associations assoc
7512: WHERE
7513: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7514: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7515: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'

Line 7539: inl_associations a

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
7543: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC

Line 7568: inl_associations assoc

7564: INTO
7565: l_alc_zero
7566: FROM
7567: inl_charge_lines cl,
7568: inl_associations assoc
7569: WHERE
7570: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7571: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7572: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'

Line 7602: inl_associations a

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
7606: AND NVL(cl.match_id,cl.match_amount_id) IS NOT NULL --only ALC

Line 7625: inl_associations assoc

7621: INTO
7622: l_alc_zero
7623: FROM
7624: inl_charge_lines cl,
7625: inl_associations assoc
7626: WHERE
7627: assoc.ship_header_id = affected_by_elc_lst(k).ship_header_id
7628: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
7629: AND assoc.to_parent_table_id = affected_by_elc_lst(k).to_parent_table_id

Line 8907: FROM inl_associations

8903: p_debug_info => l_debug_info
8904: ) ;
8905: SELECT MAX(association_id) --Bug#9907327
8906: INTO l_AssocLn.association_id
8907: FROM inl_associations
8908: WHERE from_parent_table_name = 'INL_CHARGE_LINES'
8909: AND from_parent_table_id = l_new_charge_line_id
8910: AND to_parent_table_name = c_matches(i).to_parent_table_name
8911: AND to_parent_table_id = c_matches(i).to_parent_table_id

Line 11453: FROM inl_associations assoc

11449: INTO l_charge_line_num
11450: FROM inl_charge_lines cl
11451: WHERE NVL (cl.parent_charge_line_id, cl.charge_line_id) IN(
11452: SELECT assoc.from_parent_table_id
11453: FROM inl_associations assoc
11454: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
11455: AND assoc.ship_header_id = p_ship_header_id);
11456:
11457: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

Line 11572: INSERT INTO inl_associations(association_id, -- 01

11568: p_procedure_name => l_program_name,
11569: p_debug_info => l_debug_info);
11570:
11571: -- Create associations according to adjustment_flag
11572: INSERT INTO inl_associations(association_id, -- 01
11573: ship_header_id, -- 02
11574: from_parent_table_name, -- 03
11575: from_parent_table_id, -- 04
11576: to_parent_table_name, -- 05

Line 11586: (SELECT INL_ASSOCIATIONS_S.NEXTVAL, -- 01

11582: last_updated_by, -- 11
11583: last_update_date, -- 12
11584: last_update_login, -- 13
11585: adjustment_type_flag) -- 14
11586: (SELECT INL_ASSOCIATIONS_S.NEXTVAL, -- 01
11587: a.ship_header_id, -- 02
11588: a.from_parent_table_name, -- 03
11589: l_charge_line_id, -- 04
11590: a.to_parent_table_name, -- 05

Line 12803: FROM inl_associations a,

12799: IS
12800: SELECT a.ship_header_id ,
12801: sh.ship_status_code ship_status,
12802: sh.pending_matching_flag
12803: FROM inl_associations a,
12804: inl_ship_headers sh
12805: WHERE sh.ship_header_id = a.ship_header_id
12806: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12807: AND a.from_parent_table_id = p_charge_line_id

Line 13479: FROM inl_associations

13475: WHERE ship_header_id = p_ship_header_id;
13476:
13477: SELECT NVL(MAX(last_update_date), min_date)
13478: INTO l_assoc_last_update_date
13479: FROM inl_associations
13480: WHERE ship_header_id = p_ship_header_id;
13481:
13482: SELECT NVL(MAX(last_update_date), min_date)
13483: INTO l_tax_last_update_date

Line 13899: FROM inl_associations a

13895: FROM inl_charge_lines cl
13896: WHERE cl.adjustment_type_flag = 'A'
13897: AND cl.parent_charge_line_id IS NULL
13898: AND EXISTS (SELECT 1
13899: FROM inl_associations a
13900: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
13901: AND a.from_parent_table_id = cl.charge_line_id
13902: AND a.adjustment_type_flag = 'A'
13903: AND a.ship_header_id = p_ship_header_id

Line 13907: FROM inl_associations a

13903: AND a.ship_header_id = p_ship_header_id
13904: AND ROWNUM < 2
13905: )
13906: AND NOT EXISTS (SELECT 1
13907: FROM inl_associations a
13908: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
13909: AND a.from_parent_table_id = cl.charge_line_id
13910: AND a.adjustment_type_flag IS NOT NULL
13911: AND a.adjustment_type_flag <> 'A'

Line 13997: FROM inl_associations a

13993: CONNECT BY PRIOR cl1.charge_line_id = cl1.parent_charge_line_id
13994: )
13995: AND EXISTS (
13996: SELECT 1
13997: FROM inl_associations a
13998: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
13999: AND a.ship_header_id = p_ship_header_id
14000: AND a.from_parent_table_id = (
14001: SELECT

Line 14030: DELETE FROM inl_associations a

14026: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
14027: p_procedure_name => l_program_name,
14028: p_debug_info => l_debug_info);
14029:
14030: DELETE FROM inl_associations a
14031: WHERE a.adjustment_type_flag = 'A'
14032: AND a.ship_header_id = p_ship_header_id
14033: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
14034: AND a.from_parent_table_id = ( --Charge Line should be the top of charge lines

Line 14064: UPDATE inl_associations a

14060: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
14061: p_procedure_name => l_program_name,
14062: p_debug_info => l_debug_info);
14063:
14064: UPDATE inl_associations a
14065: SET a.adjustment_type_flag = NULL,
14066: a.last_update_login = l_fnd_login_id,
14067: a.last_update_date = SYSDATE,
14068: a.last_updated_by = l_fnd_user_id