DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_FREIGHT_COST_TYPES

Line 1692: FROM wsh_freight_costs wfc, wsh_freight_cost_types wfct

1688: wfc.currency_code,
1689: NVL(wfc.conversion_type_code, 'Corporate'),
1690: NVL(wfc.conversion_date, SYSDATE),
1691: wfc.conversion_rate
1692: FROM wsh_freight_costs wfc, wsh_freight_cost_types wfct
1693: WHERE wfc.stop_id = c_stop_id AND
1694: NVL(wfc.charge_source_code, 'MANUAL') = 'PRICING_ENGINE' AND
1695: NVL(wfc.line_type_code, 'CHARGE') ='SUMMARY' AND
1696: wfc.freight_cost_type_id <> -1 AND

Line 1854: FROM wsh_freight_costs wfc, wsh_freight_cost_types wfct

1850: wfc.currency_code,
1851: NVL(wfc.conversion_type_code, 'Corporate'),
1852: NVL(wfc.conversion_date, SYSDATE),
1853: wfc.conversion_rate
1854: FROM wsh_freight_costs wfc, wsh_freight_cost_types wfct
1855: WHERE wfc.trip_id = c_trip_id AND
1856: NVL(wfc.charge_source_code, 'MANUAL') = 'PRICING_ENGINE' AND
1857: NVL(wfc.line_type_code, 'CHARGE') ='SUMMARY' AND
1858: wfc.freight_cost_type_id <> -1 AND