APPS.WSH_FC_INTERFACE_PKG dependencies on OE_CHARGE_LINES_V

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

3710: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PRORATE_FREIGHT_CHARGE';
3711: --
3712: BEGIN
3713: -- User delivery detail to find source line id instead of selecting from
3714: -- oe_charge_lines_v because each source_line_id could have multiple charges
3715: --
3716: -- Debug Statements
3717: --
3718: --

Line 3742: FROM oe_charge_lines_v

3738: wsh.source_code = 'OE';
3739:
3740: SELECT COUNT(*)
3741: INTO l_check
3742: FROM oe_charge_lines_v
3743: WHERE line_id = l_line_id AND charge_id = p_charge_id;
3744:
3745: IF (l_check = 0) THEN
3746: RAISE Input_Inconsistent;

Line 3795: FROM oe_charge_lines_v

3791: CLOSE C_Details_Assigned;
3792:
3793: SELECT charge_amount, currency_code
3794: INTO l_amount, l_currency_code
3795: FROM oe_charge_lines_v
3796: WHERE charge_id = p_charge_id;
3797:
3798: SELECT shipped_quantity, requested_quantity_uom , inventory_item_id
3799: INTO l_unit, l_uom , l_inventory_item_id