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_INTERFACE_PVT dependencies on INL_SHIP_LINE_GROUPS

Line 1493: inl_ship_line_groups g

1489: AND NOT EXISTS
1490: (
1491: SELECT 1
1492: FROM inl_ship_lines_all l,
1493: inl_ship_line_groups g
1494: WHERE l.ship_line_id = a.ship_line_id
1495: AND l.ship_line_group_id = g.ship_line_group_id
1496: AND NVL(a.ship_line_group_reference, FND_API.G_MISS_CHAR) = NVL(g.ship_line_group_reference, FND_API.G_MISS_CHAR)
1497: AND a.ship_line_src_type_code = g.src_type_code

Line 1542: inl_ship_line_groups g

1538: AND NOT EXISTS
1539: (
1540: SELECT 1
1541: FROM inl_ship_lines_all l,
1542: inl_ship_line_groups g
1543: WHERE l.ship_line_id = a.ship_line_id
1544: AND l.ship_line_group_id = g.ship_line_group_id
1545: AND NVL(a.ship_line_group_reference, FND_API.G_MISS_CHAR) = NVL(g.ship_line_group_reference, FND_API.G_MISS_CHAR)
1546: AND a.ship_line_src_type_code = g.src_type_code

Line 2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

2170: -- Utility name : Delete_Ship
2171: -- Type : Private
2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,
2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,
2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
2175: -- Pre-reqs : None
2176: -- Parameters :
2177: -- IN : p_ship_header_id IN NUMBER
2178: --

Line 2263: l_debug_info := 'Delete from inl_ship_line_groups';

2259: ) ;
2260: DELETE FROM inl.inl_ship_lines_all
2261: WHERE ship_header_id = p_ship_header_id;
2262:
2263: l_debug_info := 'Delete from inl_ship_line_groups';
2264: INL_LOGGING_PVT.Log_Statement(
2265: p_module_name => g_module_name,
2266: p_procedure_name => l_proc_name,
2267: p_debug_info => l_debug_info

Line 2269: DELETE FROM inl.inl_ship_line_groups

2265: p_module_name => g_module_name,
2266: p_procedure_name => l_proc_name,
2267: p_debug_info => l_debug_info
2268: ) ;
2269: DELETE FROM inl.inl_ship_line_groups
2270: WHERE ship_header_id = p_ship_header_id;
2271:
2272: l_debug_info := 'Delete from inl_ship_headers_all';
2273: INL_LOGGING_PVT.Log_Statement(

Line 2778: FROM inl_ship_line_groups

2774: rec_ship_line_groups.attribute12, /* 21 */
2775: rec_ship_line_groups.attribute13, /* 22 */
2776: rec_ship_line_groups.attribute14, /* 23 */
2777: rec_ship_line_groups.attribute15 /* 24 */
2778: FROM inl_ship_line_groups
2779: WHERE ship_header_id = p_ship_header_id
2780: AND NVL(src_type_code, FND_API.G_MISS_CHAR)= NVL(validLines_List(p_line_index).ship_line_src_type_code, FND_API.G_MISS_CHAR)
2781: AND party_id = validLines_List(p_line_index).party_id
2782: AND party_site_id = validLines_List(p_line_index).party_site_id

Line 2788: SELECT inl_ship_line_groups_s.NEXTVAL

2784: AND NVL(ship_line_group_reference, FND_API.G_MISS_NUM)= NVL(validLines_List(p_line_index).ship_line_group_reference, FND_API.G_MISS_NUM) ;
2785: EXCEPTION
2786: WHEN NO_DATA_FOUND THEN
2787: -- Create a Line Group record
2788: SELECT inl_ship_line_groups_s.NEXTVAL
2789: INTO rec_ship_line_groups.ship_line_group_id
2790: FROM dual;
2791: SELECT MAX(ship_line_group_num)
2792: INTO rec_ship_line_groups.ship_line_group_num

Line 2793: FROM inl_ship_line_groups

2789: INTO rec_ship_line_groups.ship_line_group_id
2790: FROM dual;
2791: SELECT MAX(ship_line_group_num)
2792: INTO rec_ship_line_groups.ship_line_group_num
2793: FROM inl_ship_line_groups
2794: WHERE ship_header_id = p_ship_header_id;
2795:
2796: rec_ship_line_groups.ship_line_group_num := NVL(rec_ship_line_groups.ship_line_group_num, 0) + 1;
2797: rec_ship_line_groups.ship_line_group_reference := validLines_List(p_line_index).ship_line_group_reference;

Line 2819: l_debug_info := 'Inserting inl_ship_line_groups';

2815: rec_ship_line_groups.attribute12 := validLines_List(p_line_index).attribute12_lg;
2816: rec_ship_line_groups.attribute13 := validLines_List(p_line_index).attribute13_lg;
2817: rec_ship_line_groups.attribute14 := validLines_List(p_line_index).attribute14_lg;
2818: rec_ship_line_groups.attribute15 := validLines_List(p_line_index).attribute15_lg;
2819: l_debug_info := 'Inserting inl_ship_line_groups';
2820: INL_LOGGING_PVT.Log_Statement(
2821: p_module_name => g_module_name,
2822: p_procedure_name => l_proc_name,
2823: p_debug_info => l_debug_info

Line 2831: INSERT INTO inl_ship_line_groups (

2827: p_procedure_name => l_proc_name,
2828: p_var_name => 'rec_ship_line_groups.ship_line_group_id',
2829: p_var_value => rec_ship_line_groups.ship_line_group_id
2830: ) ;
2831: INSERT INTO inl_ship_line_groups (
2832: ship_line_group_id, /* 01 */
2833: ship_line_group_reference, /* 02 */
2834: ship_header_id, /* 03 */
2835: ship_line_group_num, /* 04 */

Line 3882: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN

3878: SELECT ship_header_id
3879: INTO x_ship_header_id
3880: FROM inl_ship_lines
3881: WHERE ship_line_id = x_new_to_parent_table_id;
3882: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
3883: SELECT ship_header_id
3884: INTO x_ship_header_id
3885: FROM inl_ship_line_groups
3886: WHERE ship_line_group_id = x_new_to_parent_table_id;

Line 3885: FROM inl_ship_line_groups

3881: WHERE ship_line_id = x_new_to_parent_table_id;
3882: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
3883: SELECT ship_header_id
3884: INTO x_ship_header_id
3885: FROM inl_ship_line_groups
3886: WHERE ship_line_group_id = x_new_to_parent_table_id;
3887: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
3888: l_ship_header_id_tab.DELETE;
3889: SELECT DISTINCT(a.ship_header_id) BULK COLLECT

Line 6292: 'INL_SHIP_LINE_GROUPS',

6288: ) ;
6289:
6290: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
6291: 'INL_SHIP_LINES',
6292: 'INL_SHIP_LINE_GROUPS',
6293: 'INL_CHARGE_LINES',
6294: 'INL_TAX_LINES',
6295: 'RCV_TRANSACTIONS'
6296: )

Line 6325: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN

6321: WHERE ship_line_id = p_to_parent_table_id;
6322: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
6323: l_matchTpCdOk := 'Y';
6324: END IF;
6325: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
6326: l_INT_importedOk := 'Y';
6327: SELECT ship_header_id
6328: INTO l_ship_header_id
6329: FROM inl_ship_line_groups

Line 6329: FROM inl_ship_line_groups

6325: ELSIF p_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
6326: l_INT_importedOk := 'Y';
6327: SELECT ship_header_id
6328: INTO l_ship_header_id
6329: FROM inl_ship_line_groups
6330: WHERE ship_line_group_id = p_to_parent_table_id;
6331: IF p_match_type_code = 'CHARGE' THEN
6332: l_matchTpCdOk := 'Y';
6333: END IF;