DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1782: wms_license_plate_numbers wlpn

1778: IF p_serial_number IS NULL THEN
1779: SELECT ccg.cost_group_id, ccg.cost_group
1780: INTO x_cost_group_id, x_cost_group
1781: FROM cst_cost_groups ccg, wms_lpn_contents wlc,
1782: wms_license_plate_numbers wlpn
1783: WHERE ccg.cost_group_id = wlc.cost_group_id
1784: AND (wlc.lot_number = p_lot_number
1785: OR (p_lot_number IS NULL AND wlc.lot_number IS NULL))
1786: AND (wlc.revision = p_revision