APPS.INL_SHIPMENT_PVT dependencies on INL_ASSOCIATIONS

Line 1863: inl_associations assoc

1859: cl.charge_line_id,
1860: cl.charge_line_num
1861: FROM inl_adj_charge_lines_v cl,
1862: inl_charge_line_types_vl clt ,
1863: inl_associations assoc
1864: WHERE clt.charge_line_type_id = cl.charge_line_type_id
1865: AND assoc.from_parent_table_name = 'INL_CHARGE_LINES'
1866: AND assoc.from_parent_table_id = NVL (cl.parent_charge_line_id, cl.charge_line_id)
1867: AND assoc.ship_header_id = p_ship_header_id

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

2663: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
2664: p_procedure_name => l_proc_name) ;
2665: -- Initialize return status to success
2666: x_return_status := FND_API.G_RET_STS_SUCCESS;
2667: l_debug_info := 'Insert in inl_associations.';
2668: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2669: p_procedure_name => l_proc_name,
2670: p_debug_info => l_debug_info) ;
2671: l_debug_info := 'p_new_line_id';

Line 2678: INTO inl_associations (

2674: p_var_name => l_debug_info,
2675: p_var_value => TO_CHAR (p_new_line_id)) ;
2676:
2677: INSERT
2678: INTO inl_associations (
2679: association_id, /* 01 */
2680: ship_header_id, /* 02 */
2681: from_parent_table_name, /* 03 */
2682: from_parent_table_id, /* 04 */

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

2690: last_update_date, /* 12 */
2691: last_update_login /* 13 */
2692: )
2693: VALUES (
2694: inl_associations_s.nextval, /* 01 */
2695: p_Assoc.ship_header_id, /* 02 */
2696: p_from_parent_table_name, /* 03 */
2697: p_new_line_id, /* 04 */
2698: p_Assoc.to_parent_table_name, /* 05 */

Line 3028: FROM inl_associations assoc

3024: )
3025: AND EXISTS
3026: (
3027: SELECT 1
3028: FROM inl_associations assoc
3029: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
3030: AND assoc.from_parent_table_id = tl.tax_line_id
3031: AND assoc.to_parent_table_name = p_comp_name
3032: AND assoc.to_parent_table_id = p_comp_id

Line 3930: FROM inl_associations assoc

3926: FROM inl_charge_lines cl
3927: WHERE NVL (cl.parent_charge_line_id, cl.charge_line_id) IN
3928: (
3929: SELECT assoc.from_parent_table_id
3930: FROM inl_associations assoc
3931: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
3932: AND assoc.ship_header_id = NVL (p_ChLn_Assoc.inl_Assoc.ship_header_id, 0)
3933: ) ;
3934: ELSE

Line 4135: FROM inl_associations assoc,

4131: SELECT
4132: assoc.to_parent_table_name,
4133: assoc.to_parent_table_id,
4134: assoc.ship_header_id
4135: FROM inl_associations assoc,
4136: inl_charge_lines cl
4137: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
4138: AND assoc.from_parent_table_id = cl.charge_line_id
4139: AND cl.charge_line_type_id = p_charge_line_type_id

Line 4217: FROM inl_associations assoc

4213: AND cl.charge_line_type_id = p_charge_line_type_id
4214: AND EXISTS
4215: (
4216: SELECT 1
4217: FROM inl_associations assoc
4218: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
4219: AND assoc.from_parent_table_id = NVL (cl.parent_charge_line_id, cl.charge_line_id)
4220: AND (
4221: (

Line 6820: FROM inl_associations a,

6816: IS
6817: SELECT a.ship_header_id ,
6818: sh.ship_status_code ship_status,
6819: sh.pending_matching_flag
6820: FROM inl_associations a,
6821: inl_ship_headers sh
6822: WHERE sh.ship_header_id = a.ship_header_id
6823: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
6824: AND a.from_parent_table_id = p_charge_line_id