APPS.WSH_FC_INTERFACE_PKG dependencies on OE_CHARGE_LINES_V

Line 3707: -- oe_charge_lines_v because each source_line_id could have multiple charges

3703: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PRORATE_FREIGHT_CHARGE';
3704: --
3705: BEGIN
3706: -- User delivery detail to find source line id instead of selecting from
3707: -- oe_charge_lines_v because each source_line_id could have multiple charges
3708: --
3709: -- Debug Statements
3710: --
3711: --

Line 3735: FROM oe_charge_lines_v

3731: wsh.source_code = 'OE';
3732:
3733: SELECT COUNT(*)
3734: INTO l_check
3735: FROM oe_charge_lines_v
3736: WHERE line_id = l_line_id AND charge_id = p_charge_id;
3737:
3738: IF (l_check = 0) THEN
3739: RAISE Input_Inconsistent;

Line 3788: FROM oe_charge_lines_v

3784: CLOSE C_Details_Assigned;
3785:
3786: SELECT charge_amount, currency_code
3787: INTO l_amount, l_currency_code
3788: FROM oe_charge_lines_v
3789: WHERE charge_id = p_charge_id;
3790:
3791: SELECT shipped_quantity, requested_quantity_uom , inventory_item_id
3792: INTO l_unit, l_uom , l_inventory_item_id