DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on INL_SHIPLN_LANDED_COSTS_V

Line 1858: FROM inl_shipln_landed_costs_v islv

1854:
1855: -- Get the New Unit Landed Cost
1856: SELECT islv.unit_landed_cost
1857: INTO l_new_landed_cost
1858: FROM inl_shipln_landed_costs_v islv
1859: WHERE islv.adjustment_num = ship_ln_list(i).adjustment_num
1860: AND islv.ship_header_id = p_ship_header_id
1861: AND islv.ship_line_group_id = ship_ln_list(i).ship_line_group_id --Bug 7678900
1862: AND islv.ship_line_num = ship_ln_list(i).ship_line_num;

Line 1867: FROM inl_shipln_landed_costs_v islv

1863:
1864: -- Get the Prior Unit Landed Cost
1865: SELECT islv.unit_landed_cost
1866: INTO l_prior_landed_cost
1867: FROM inl_shipln_landed_costs_v islv
1868: WHERE islv.adjustment_num = ship_ln_list(i).adjustment_num - 1
1869: AND islv.ship_header_id = p_ship_header_id
1870: AND islv.ship_line_group_id = ship_ln_list(i).ship_line_group_id --Bug 7678900
1871: AND islv.ship_line_num = ship_ln_list(i).ship_line_num;